Modeling for Heterogeneous Replications with Replication Agents and ECDA

Heterogeneous databases are databases other than Sybase Adaptive Server Enterprise or Adaptive Server Anywhere/SQL Anywhere®. Replication agents allow Replication Server to communicate with heterogeneous primary databases.

Modeling a Heterogeneous Primary Database

The replication agent captures the changes made in the primary database and sends the transaction log to the primary Replication Server. To model for a heterogeneous primary database using a replication agent, you need to:

Specify server objects to contain the primary database and replication process, each with the appropriate host machine name and port number (see Server Properties).
Specify the appropriate properties for the Replication Server connection and RSSD database on the RepServer Connection tab of the replication process property sheet (see Replication Server Properties)
Specify the RepAgent type, the RepAgent user (to access the replication server), the primary database user (to access the database), and the other properties on the RepAgent Options tab of the primary database property sheet (see Replication Server Primary Database Properties).

Note: In order to generate and execute the replication agent SQL file using isql, you must select the "Execute generated scripts in Replication Agent" on the Tasks tab of the Generation window (see Generating for Replication Server).

Modeling a Heterogeneous Replicate Database

The ECDA communicates replicated data from a replication server to a heterogeneous replicate database. To model for a heterogeneous replicate database, you need to:

Specify server objects to contain the replicate database and replication process, each with the appropriate host machine name and port number (see Server Properties).
Specify the DirectConnect™ instance name in the Code of the replicate database in its property sheet (see Replication Server Primary Database Properties).