Defining the replication environment

The replication environment is an object in Replication Manager that represents all servers that participate in replication. Your first step in setting up replication is to define the replication environment.

The Add Replication Environment wizard of the Replication Manager guides you through the steps necessary to add the Replication Server, the primary Adaptive Server, and the replicate Adaptive Server.

Record the user names and passwords that you define, as you will need this information later on.

StepsDefining the replication environment

This section uses the sample Replication Server named SAMPLE_RS created during installation. Be sure to start the sample Replication Server before working through the following steps:

  1. From the Sybase Central main window, select the Replication Manager icon in the left pane.

  2. In the right pane, double-click Add Replication Environment. The Add Environment wizard appears.

  3. Enter a name for your replication environment.

    Example: MY_RSENV

  4. Click Next.

  5. Enter a user name, password, and retype the password in the confirmation field to access the replication environment. Click Next.

    • User name _________________

    • Password __________________

    • Confirm Password __________________

  6. Click Add. Select the type of server to add to the environment. To add the sample Replication Server, select Replication Server. Click Next.

  7. Select SAMPLE_RS from the Servers drop-down list. Click Next.

  8. Enter user name and password:

    • User name – sa

    • Password – none (no password)

    Click Next.

  9. The Select RSSD Server window appears. Click Next.

  10. Enter user name and password:

    • User name – SAMPLE_RS_RSSD_prim

    • Password – SAMPLE_RS_RSSD_prim_ps

    Click Next.

  11. Click Finish.

  12. Click Add to add Adaptive Server Enterprise containing the primary database to the environment. Select Adaptive Server Enterprise and click Next.

  13. Select the primary Adaptive Server Enterprise from the Servers drop-down list. Click Next.

    Add a user name and password that Replication Manager can use to log in to the primary database. This user must be the System Administrator, or the equivalent, with sso_role and sa_role.

    • User name ________________

    • Password _________________

    Click Finish.

  14. Click Add to add Adaptive Server Enterprise containing the replicate database to the environment. Select Adaptive Server Enterprise and click Next.

  15. Select the replicate Adaptive Server Enterprise from the Servers drop-down list. Click Next.

    Add a user name and password that Replication Manager can use to log in to the replicate database. This user must be the System Administrator, or the equivalent, with sso_role and sa_role.

    • User name ________________

    • Password _________________

    Click Finish.

  16. Click Next.

    Check the summary page to make sure the information is correct and complete.

    If the information is not correct, click Back to return to previous pages and correct the information.

  17. Click Finish.

  18. Sybase Central redisplays. The new replication environment icon appears in the left pane beneath the Replication Manager icon, displaying the name you had specified for it.