Chapter 12 Working with Replication Server

Managing heterogeneous replications

If you use Replication Server with heterogeneous databases (non-Sybase ASA or Sybase ASE), you must install RepAgent for primary database and Direct Connect for remote database. A replication agent allows for communication between Replication Server and the databases.

Sybase ASE has a built-in replication agent. Users do not need to install RepAgent.

The replication agent captures the changes made in the primary database and sends the transaction log to the primary Replication Server.

The replication agent needs to connect to:

• Primary database
• Primary Replication Server
• RSSD database of the Primary Replication Server

The replication agent needs to be configured to connect to the Primary Database, Primary Replication Server and RSSD database of the Primary Replication Server.

You need to indicate which table, stored procedure, or large column is to be replicated using the replication agent commands.

Replication Agent configuration

To configure the replication agent, you need to:

• Set the Use replication agent extended attribute to True in the primary database; this is not necessary if the PDM of the primary database is defined and open in the workspace
• Define the host name, port number, database name, user name and password of the primary database; and define the primary Replication Server, and RSSD database of the primary Replication Server
• Generate and execute a SQL script for Replication Agent using isql

For more information about the replication agent configuration, see section RepAgent.

Replication Agent generation

In order to generate and execute the replication agent SQL file using isql, you need to:

• Enter the replication agent instance name in the RepAgent name extended attribute of the primary database
• Enter the replication agent login user name and password in the RepAgent user name and RepAgent password extended attributes of the primary database
• Select the Generate Scripts command from the primary database contextual menu
• In the Tasks tab, select the "Execute generated scripts in Replication Agent" command
  

DirectConnect

When the remote database is not a Sybase ASE or Sybase ASA database, you need to use DirectConnect to communicate with the remote database.

In the remote database object, you must enter the DirectConnect instance name in the Code of the remote database.

Copyright (C) 2007. Sybase Inc. All rights reserved.