Running Replication Agent and Microsoft SQL Server on different machines

Do the following to run Replication Agent and the primary Microsoft SQL Server data server on different machines.

StepsSetting up Replication Agent and Microsoft SQL Server to run on different machines

  1. Install the sybfilter driver on the same machine as the primary Microsoft SQL Server, and use this driver to make the transaction logs readable for Replication Agent.

  2. On the machine on which the primary Microsoft SQL Server is running, share the drive or drives containing the transaction log files so that the drives can be mounted on the machine on which Replication Agent is to be installed.

  3. Install the Replication Agent on a machine of the same type of hardware and operating system as the machine on which the primary Microsoft SQL Server data server is running.

  4. Install the Microsoft SQL Server JDBC driver on the same machine as Replication Agent.

  5. On the Replication Agent machine, map network drives that contain the primary Microsoft SQL Server database transaction log files. Use the ra_devicepath command to point Replication Agent to the mapped database log files.