Each primary or replicate database in a replication system is managed by a Replication Server.
Follow the steps below to add a database to the replication system. To use these instructions, you need the completed “Database Setup Worksheet.” If you have not completed the worksheet, read Chapter 1, “Preparing to Install and Configure Replication Server” and complete it before you continue.
Adding a database to the replication system
From the RS_INIT menu, select Configure a Server Product.
Select Replication Server. You see the Configure Replication System screen.
Select Add a Database to the Replication System. rs_init indicates the status of each part of the installation with “Incomplete” or “Complete.”
Select Replication Server Information.
Select Replication Server Name. Enter the name of the Replication Server from your worksheet. Press Ctrl+A to accept your changes.
Complete the screen, using the information you recorded on your worksheet.
If the status of Replication Server Interfaces Information is “Incomplete,” see “Editing the interfaces file” for help in adding an entry for the Replication Server.
Press Ctrl+A to accept your changes and return to the Add Database to Replication System screen.
Completing database information
Follow these steps to add a database.
In the Add Database to Replication System screen, select Database Information.
Complete the screen, using the information you recorded on the worksheet. If you use a default value, copy it from the screen to your worksheet. The label refers to Adaptive Server as “SQL Server.”
The password you specify in this step must be valid to log in to Adaptive Server as “sa”. You cannot change the password in rs_init by specifying a different password in this screen. To change the Adaptive Server “sa” password, log in to the Adaptive Server after installation and change the password using the alter user command.
Choose Yes for “Will the Database Be Replicated?” if:
It contains primary data.
It is part of a warm standby application.
Applications execute replicated stored procedures in it.
See “Planning the replication system” for more information about when a database requires a RepAgent.
If you are adding the active or standby database for a warm standby application:
Choose Yes for “Is This a Physical Connection for Existing Logical Connection?”
Specify the additional information in the Logical DB Setup screen. See “Logical connection information” for details.
Press Ctrl+A to accept your changes, then go to “Completing the configuration”.
Logical connection information
This section describes entries you make in the Logical Connection Information screen when you add an active or standby database for a warm standby application.
Read Chapter 3, “Managing Warm Standby Applications” in the Replication Server Administration Guide Volume 2, before performing the steps described in this section.
Before you use rs_init to add a database for a warm standby application, you must create the logical connection in the Replication Server.
If you selected Yes for “Is This a Physical Connection for Existing Logical Connection?” in the Database Information screen, Logical Database Setup selections appear. You must specify logical connection parameters.
In the Database Information screen, select Logical DB Setup.
The Logical Connection Information screen appears. When you choose “active” for the first item, only these items appear:
Logical DS Name
Logical DB Name
Complete the Logical Connection Information screen, using the information you recorded on your worksheet. If you use a default value, copy it from the screen to your worksheet.
Press Ctrl+A to accept your changes, and rs_init returns you to the Database Information screen.
Completing the configuration
If the Database Information window indicates that there are incomplete tasks on the Add Database to Replication System screen, select each one and complete the required information.
When all tasks are “Complete,” press Ctrl+A. A message is displayed asking you if you want to execute the configuration.
Enter “y” to continue with the configuration.
Messages appear on the screen as the configuration progresses; these messages require no action.
Do not interrupt the configuration. Most configurations require several minutes (sometimes longer) to complete.
When the configuration is complete, rs_init displays “Configuration completed successfully.”
Click OK to return to the Configure Replication System dialog box.
To add other databases to the replication system, go to “Adding a database to the replication system”, and repeat the procedure for each database.
Press Ctrl+X to navigate through the screens and exit the program. rs_init displays the path to the log file for the session before you return to the command prompt.
You can find out more about the progress of the installation by looking at the current rs_init log file. rs_init log files are stored in the init/logs subdirectory of the $SYBASE_REP directory.