Setting Up the Sample Replication System

Use the Adaptive Servers or Replication Servers that you have already installed in setting up the sample replication system. Substitute the names of your servers throughout the instructions.

Prerequisites
Choose the machines where each server will execute and locate disk space for Adaptive Server database devices and Replication Server partitions. See the Replication Server Installation Guide for disk space and system requirements.
Task
  1. Install the primary Adaptive Server, TOKYO_DS.
  2. Install the replicate Adaptive Server, SYDNEY_DS.
  3. Install the pubs2 database in the primary Adaptive Server:
    isql -Usa -Psa_passwd -STOKYO_DS < \
    %SYBASE%\%SYBASE_ASE%\scripts\installpubs2
  4. Install the pubs2 database in the replicate Adaptive Server:
    isql -Usa -Psa_passwd -SSYDNEY_DS < \
    %SYBASE%\%SYBASE_ASE%\scripts\installpubs2
  5. Complete the Replication Server Installation worksheet for the primary Replication Server (TOKYO_RS).
    • Create the RSSD for TOKYO_RS in the TOKYO_DS Adaptive Server.
    • The RSSD requires a RepAgent.
  6. Complete the Replication Server Installation worksheet for the replicate Replication Server (SYDNEY_RS).
    • Create the RSSD for SYDNEY_RS in the SYDNEY_DS Adaptive Server.
    • The RSSD does not require a RepAgent.
  7. Complete the Database Setup worksheet for the primary pubs2 database.
    • The database is in Adaptive Server TOKYO_DS.
    • The database is managed by the TOKYO_RS Replication Server.
    • The database requires a RepAgent.
  8. Complete the Database Setup worksheet for the replicate pubs2 database.
    • The database is in Adaptive Server SYDNEY_DS.
    • The database is managed by the SYDNEY_RS Replication Server.
    • The database does not require a RepAgent.
  9. Log in to the machine where the primary Replication Server will execute. Run rs_init and install Replication Server TOKYO_RS using the worksheet you completed in step 5.
  10. Log in to the machine where you installed the primary Replication Server. Run rs_init and add the primary pubs2 database to the replication system using the worksheet you completed in step 7.
  11. Log in to the machine where the replicate Replication Server will execute. Run rs_init and install Replication Server SYDNEY_RS using the worksheet you completed in step 6.
  12. Log in to the machine where you installed the replicate Replication Server. Run rs_init and add the replicate pubs2 database to the replication system using the worksheet you completed in step 8.
Related reference
Replication Server Installation Worksheet Sample
Database Setup Worksheet Sample