Set Up a Replication System

Learn the basic steps in setting up a replication system. This process requires planning and careful attention to the replication needs of your organization.

If you are new to Replication Server, refer first to the Replication Server Design Guide for information that can help you plan your replication system.

You can perform some of these steps in rs_init, Replication Server configuration utility, which allows you to configure Replication Servers and add databases to your system. You can use Sybase Central to perform most of the tasks listed here, including adding databases, creating replication definitions, and creating subscriptions.

Before you set up replication system, install your Sybase software according to the Replication Server Installation Guide for your platform.

After you install Replication Server, use the rs_init utility program to start and configure the replication system and to add databases.

See the Replication Server Configuration Guide for more information about rs_init.

• Create Connections and Routes
  To replicate data from one database into another, you must first establish the routes and connections that allow Replication Server to move the data from its source to its destination.
• Set Permissions and Security
  Set up login names, passwords, and permissions to establish Replication Server security for the replication system.
• Verify the Replication System
  You must verify that the entire replication system is working before you create replication definitions or subscriptions or perform system diagnostics.
• Create Replication Definitions
  To set up a table for replication, mark it as replicated in Adaptive Server and define a replication definition for it in Replication Server. The replication definition describes the table and contains information about the columns to be replicated.
• Create Subscriptions
  If you create a replication definition for a table at Replication Server, you must create a subscription for that table replication definition at the replicate database. A subscription instructs Replication Server to copy data from primary tables to specified replicate databases.