Execute the test transaction script in Microsoft SQL Server  Clean up the test environment

Chapter 3: Replication Agent for Microsoft SQL Server

Check results of replication

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_select_test_primary.sql script to view the changes in the test primary table in the primary database.

NoteThis script (mssql_select_test_primary.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.

Use isql or another query processor to log in to the replicate database and execute the ase_select_test_replicate.sql script to verify that the transactions generated in the primary database were replicated to the test replicate table in the replicate database.





Copyright © 2005. Sybase Inc. All rights reserved. Clean up the test environment

View this book as PDF