Configuring Replication

Create connections between servers, a database replication definition, and a database subscription.

1. In the left pane of the Sybase Central main window, select the replication environment object you created.
2. In the right pane, double-click Configure Replication.
3. Select Create an Environment Where the Primary Database is Replicated to Several Replicate Sites. Click Next.
4. Select the primary Adaptive Server and the primary database. For example, select the pubs2 or pubs3. Click Next.
5. Select SAMPLE_RS. Click Next.
6. Select the replicate Adaptive Server and the replicate database. Click Add.
   Replication Manager creates a connection between the sample Replication Server and the replicate data server and database. This connection, target_server.database, appears in the Connections list. Click Next.
7. Accept the default maintenance user name and password. Replication Manager creates the maintenance user. Click Next.
8. Accept the default RepAgent user name and password.
   Replication Manager creates the RepAgent user. Click Next. Select a materialization method.
9. Select Create Subscription Without Materialization.
   This specifies that the primary and target databases are already synchronized. Click Next.
10. Review the summary of the replication environment.
    If everything looks correct, click Finish. If not, click Back to return and make the necessary changes. Click Finish when you are satisfied that the summary environment information is correct.
11. Review the summary to make sure each step was successful. Click Close.