Creating a Database Replication Definition

Create database replication definition.

1. Navigate to the %SYBASE%\RAX_15-5\scripts\sybase directory.
2. Make a copy of the rs_create_test_db_repdef.sql script named my_mssql_rs_create_test_db_repdef.sql.
3. Before executing the my_mssql_rs_create_test_db_repdef.sql script, change the value of {pds}.{pdb} to the name of the connection string you defined for the primary database, where:

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

   • pdb 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.

   This is a database replication definition example:

   create database replication definition NY_repdef1

   with primary at NY.NYmss5

   go

4. Connect to the Replication Server and enter:

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

   You see a message indicating that the database replication definition has been created.