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.
Click Continue.
Select Replication Server. You see the Configure Replication System window.
Select Add a Database to the Replication System, then click Continue. You see the status of each part of the installation with “Incomplete” or “Complete.”
Select Replication Server Information.
Click Continue.
Enter the name of the Replication Server from your worksheet. Click Continue to save your changes.
Complete the window, using the information you recorded on your worksheet, then click Continue.
If the status of Replication Server Interfaces Information is “Incomplete,” select it, then click Continue. You see an interfaces file editor window. Follow the instructions in “Editing the interfaces file” to add an entry for the Replication Server.
Click Continue to save your changes and return to the Add Database to Replication System window.
Completing database information
Follow these steps to add a database.
In the Add Database to Replication System window, select Database Information, then click Continue.
Complete the window, using the information you recorded on the worksheet. If you use a default value, copy it from the window 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 window. 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 window. See “Logical connection information” for details.
Click Continue to save your changes, then go to “Completing the configuration”.
Logical connection information
This section describes entries you make in the Logical Connection Information window when you add an active or standby database for a warm standby application.
Before performing the steps described in this section, see Chapter 3, “Managing Warm Standby Applications” in the Replication Server Administration Guide Volume 2, to set up a warm standby application between Adaptive Server databases, and see Chapter 14, “Managing Heterogeneous Warm Standby” in the Replication Server Heterogeneous Replication Guide, to set up a warm standby application between Oracle databases.
Before you add a database for a warm standby application, you must create the logical connection in the Replication Server.
If you selected Yes to “Is This a Physical Connection for Existing Logical Connection?” in the Database Information window, Logical Database Setup selections appear. You must specify logical connection parameters.
In the Database Information window, select Logical DB Setup, then choose Continue.
The Logical Connection Information window appears. When you choose “active” for the first item, only these options appear:
Logical DS Name
Logical DB Name
Complete the Logical Connection Information window, using the information you recorded on your worksheet. If you use a default value, copy it from the window to your worksheet.
Click Continue to save your changes, and rs_init returns you to the Database Information window.
If the Database Information window indicates that there are incomplete tasks on the Add Database to Replication System window, select each one and complete the required information.
When all tasks are “Complete,” click Continue. A message is displayed asking you if you want to execute the configuration.
Messages appear on the window 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 window.
To add other databases to the replication system, go
to “Adding a database to the replication system”,
and repeat the procedure for each database.
Click Exit to quit rs_init.
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.
