Setting Up Replication Agent and Microsoft SQL Server on Different Machines

Run Replication Agent and the primary data server 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 Replication Agent on a machine of the same hardware and operating system as the machine on which the primary data server is running.
  4. Install the 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 log files.