Configuring Replication Server for Replication to the Target Data Server

Create a Replication Server connection to the replicate data server

1. Navigate to the %SYBASE%\RAX-15_5\scripts\mssql directory.
2. Make a copy of the mssql_create_rs_standby_connection.sql script named my_mssql_create_rs_standby_connection.sql.
3. Before executing the my_mssql_create_rs_standby_connection.sql script against your Replication Server, change {rds}.{rdb} to the name of the connection that Replication Server uses to connect to the DirectConnect access service, where:

   • rds is the DirectConnect access service name.

   • rdb is any valid identifier. Sybase recommends that you use the Microsoft SQL Server replicate database name.

   • maintuser and password are the maintenance user and password created in ECDA Option for ODBC in step 1 of "Creating a maintenance user for replication." For example:

     create connection to rds.rdb

     using profile rs_msss_to_msss;standard

     set username maintuser

     set password "password"

     go

   Note:

   In the previous example, password is a Replication Server reserved word and therefore, must be enclosed in double quotes.

4. Create the connection to the replicate database:

   isql –Usa –P –SSAMPLE_RS -i my_mssql_create_rs_standby_connection.sql

5. Log in to SAMPLE_RS and verify the Replication Server connection to the replicate database:

   isql –Usa –P –SSAMPLE_RS

   admin who

   go

   You should see a message returned for the DSI connection msss_dco.dbname. Verify that the status is “Awaiting Message” or “Awaiting Command.”

6. Exit the isql session with the quit command.