Subscription Example

The subscription example shows you how to use RCL commands to replicate the publishers table from a primary Adaptive Server database to a replicate Adaptive Server database by creating an atomic subscription to the table replication definition. You can also do this in Sybase Central.

In the example replication system, at the:

  • Primary site:

    • The Replication Server is named TOKYO_RS.

    • The primary version of the publishers table is in the pubs2 database of the Adaptive Server named TOKYO_DS. You have added a connection from TOKYO_RS to the pubs2 database using Sybase Central or rs_init and set up a RepAgent for the database.

    • The system database for TOKYO_RS is named TOKYO_RSSD and is managed by the TOKYO_DS Adaptive Server.

    • A route exists from TOKYO_RS to SYDNEY_RS.

  • Replicate site:

    • The Replication Server is named SYDNEY_RS.

    • The replicate copy of the publishers table is in the pubs2 database of the Adaptive Server named SYDNEY_DS. You have added a connection from SYDNEY_RS to the pubs2 database using Sybase Central or rs_init.

    • The system database for SYDNEY_RS is named SYDNEY_RSSD and is managed by the SYDNEY_DS Adaptive Server.