After the copy request completes, view the contents of the source and target tables to confirm that the data was copied correctly. Use the Connect CDC Director SQL query utility or the database query utility of your choice. If using the Connect CDC Director:
-
In the context menu for your source server, select New SQL Window.
-
In Select Connection User ID, select the user you defined to have access to your sending table.
This ID selection box displays when you have defined more than one user ID for connections to the server.
-
In the Interactive SQL window, enter a SELECT statement to view your table, and click the Go or Execute one button.
-
Repeat these steps for your target server, and compare the results. Their contents should match.