After you create the replication environment, use the Replication Manager Configure Replication wizard to create connections between servers, a database replication definition, and a database subscription.
The database replication definition describes the information that can be replicated from the primary database. The database subscription describes the replicated information that the replicate database can accept. In this instance, Replication Manager creates the database replication definition and the database subscription for you.
When you successfully complete this section, you are ready to replicate data.
Steps to configure the replication environment
In the left pane of the Sybase Central main window, select the replication environment object you created.
In the right pane, double-click Configure Replication. The Configure Replication wizard displays.
Select the second option; Create an Environment Where the Primary Database is Replicated to Several Replicate Sites. Click Next.
Select the primary Adaptive Server and the primary database. For example, select the pubs2 or pubs3. Click Next.
Select SAMPLE_RS. Click Next.
Select the replicate Adaptive Server and the replicate database from the drop-down list. Click Add.
Replication Manager creates a connection between the sample Replication Server and the replicate data server and database. This connection, target_server.database, displays in the Connections list. Click Next.
Accept the default maintenance user name and password. Replication Manager creates the maintenance user. Click Next.
Accept the default RepAgent user name and password. Replication Manager creates the RepAgent user. Click Next. Replication Manager prompts you to select a materialization method.
Select Create Subscription Without Materialization.
This specifies that the primary and target databases are already synchronized. Click Next.
Review the summary of the replication environment.
If everything looks correct, click Finish. If not, click Back to return to earlier pages in the wizard and make the necessary changes. Click Finish when you are satisfied that the summary environment information is correct.
After Replication Manager finishes its configuration tasks, it displays a summary of steps performed. Review the summary to make sure each step was successful. Click Close.
You have installed a sample Replication Server, set up a replication environment, and configured that environment for replication. Congratulations! You are ready to replicate information from the primary to the replicate database.
