Creating a Database Replication Subscription

Create database replication subscription.

1. Make a copy of the rs_create_test_db_sub.sql script named my_mssql_rs_create_test_db_sub.sql.
2. Before executing the my_mssql_rs_create_test_db_sub.sql script, change {pds}.{pdb} and {rds}.{rdb} to the appropriate connection name, where:

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

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

   • rds is the DirectConnect access service name.

   • rdb is the name of the replicate database.

   Note:

   Save these values to be used later in the Replication Agent mssql.rs file.

   Here is an example of create database replication subscription:

   create subscription NY_sub1

   for database replication definition NY_repdef1

   with primary at NY.NYmss5

   with replicate at my_mssql_access_service.my_repl_db

   without materialization

   go

3. Connect to Replication Server and execute:

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

   You see a message indicating that the subscription is being created.