Creating a Replication Server Connection to the Primary Database

Create a Replication Server connection to the primary database.

1. Go to the %SYBASE%\RAX-15_5\scripts\sybase directory.
2. Make a copy of the rs_create_test_primary_connection.sql script named my_mssql_rs_create_primary_connection.sql.
3. Before executing the my_mssql_rs_create_primary_connection.sql script against your Replication Server, change {rax.test} to the name of the connection between Replication Agent and Replication Server, where:

   • rax is the name of the primary Microsoft SQL Server data server.

   • test is the name of the primary Microsoft SQL Server database.

   For example, NY.NYmss5.

   Note: Save these values to be used later for the rs_source_ds and rs_source_db parameters in the Replication Agent mssql.rs file.
4. Execute the script in Replication Server:

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

   You see a message indicating that the Replication Server connection to the primary database has been created.