Create the subscription

There are two scripts provided for this step:

StepsTo create the test subscription

NoteThis procedure assumes that no materialization is necessary. See the Sybase Replication Agent Administration Guide for more information about database materialization.

  1. Edit the appropriate script file (rs_create_test_sub.sql or rs_create_test_sub_for_11.0.x.sql) so that the values for RDS.RDB on the with replicate at clause for each command match the RDS.RDB values that you used to create the connection to the replicate data server and replicate database. These values are initially set to ase.test.

  2. Use isql or another query processor to access the replicate Replication Server and execute the appropriate script to create the test subscription.

NoteIf you are using the rs_create_test_sub_for_11.0.x.sql script, the script must be executed twice because, even though the PRS and RRS are the same Replication Server, there is not enough time between the command executions in the script to allow Replication Server to complete all its tasks before the next script command is executed. For this reason, you may want to execute the commands in this script separately.