Clean up the test environment

Use the following procedure to clean up and remove the replication test environment that you created in the previous sections.

To clean up and remove the replication test environment

1. Log in to the Replication Agent administration port using isql (or another query processor).

2. Use the following command to quiesce the Replication Agent instance:

   quiesce
   

3. Use the following command to remove the Replication Agent transaction log and unmark the test primary table (rax_test) in the Microsoft SQL Server database:

   pdb_xlog remove, force
   

4. Log in to the replicate Replication Server and execute the following scripts:

   • rs_drop_test_sub.sql or rs_drop_test_sub_for_11.0.x.sql (to drop the test subscription)

   Edit the appropriate script file (rs_drop_test_sub.sql or rs_drop_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 in the rs_create_test_sub.sql script. These values are initially set to ase.test.

   • rs_drop_test_repdef.sql (to drop the test replication definition)

   • rs_drop_test_connection.sql (to drop the test connection to the primary database)

5. Log in to the replicate data server and execute the ase_drop_test_replicate_table.sql script to drop the test replicate table.

6. Use your Microsoft SQL Server database access tool (such as Microsoft isql) to log in to the Microsoft SQL Server data server and execute the mssql_drop_test_primary_table.sql script to drop the test primary table.

   This script (mssql_drop_test_primary_table.sql) does not specify a database name. You must either edit the script to include a use command, or invoke isql with the -d option.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF