The complexity and volume of mission-critical corporate data have been growing exponentially. Sales, marketing, finance, and manufacturing databases that house vital business information typically have been deployed by organization for their internal usages. High availability of vital information on distributed platforms can bring extra-ordinary returns for business organizations. Daffodil Replicator helps in making possible the replication of the enterprise data being stored in SQL Server to distributed Sql Server clients and other heterogeneous databases (including Oracle, DB2, Daffodil DB, PostgreSql and Derby).

Maintaining ongoing database replication presents the most complex activity for Sql Server database administrators. This can be time consuming, as well as difficult to perform at off-hours, for global organizations with workers in multiple time zones. Daffodil Replicator has been able to make this complex problem look easy.

Mention below is the simple steps to configure Replicator with SQL Server (Publisher) and Daffodil DB (Subscriber)

• Download the appropriate zip file
• Extract the corresponding zip file to an appropriate folder
• Make the following changes by editing setpath.bat (windows) or startup.sh (Linux) (both for SQL server and Daffodil DB)
• Remove Rem from SET JAVA_HOME= and SET JDBC_CLASSPATH ="Replicator.jar"
• Set JAVA_HOME. JAVA_HOME is the directory path where you have installed JRE/J2SDK
  Example: SET JAVA_HOME=C:\j2sdk1.4.2
• Set JDBC_CLASSPATH for Oracle, PostgreSQL and Replicator SET JDBC_CLASSPATH= C:\ classes12.jar ; pg80b1.308.jdbc3.jar ;Replicator.jar
  Note: Directory path should not contain any blank spaces
• Run PubServer.bat/PubServer.sh to start publication server (Oracle):
• To start Publication Server on your system, run the file PubServer.bat or PubServer.sh for Linux) available under the installation directory of Daffodil Replicator and a dialog box appears.
• <
• Fill up the Data Source Information (SQL server) in the dialog box appeared
• Driver - com.ibm.db2.jcc.DB2Driver
• URL -jdbc:microsoft:sqlserver://(SQL Server server name): 1433;DatabaseName=(database name)
• Username - Enter a valid username
• Password - Enter the password of the above specified user
• System Name - Specify the name or network IP of the local machine
• Server Port No. - Specify the port no. on which you wish to run Publication Server
• Similarly, run SubServer.bat/SubServer.sh to start subscription server ((Daffodil DB Embedded Edition).
• 
  Listed below are the Driver and URL:
  
• in.co.daffodil.db.jdbc.DaffodilDBDriver
• jdbc:daffodilDB_embedded:;create=true