Replication warning system

The situation

You want to ensure that your replication is running smoothly and data is being correctly replicated. However, SQL Server provides no detail on the changes that have occurred during replication. Manual checks are time-consuming, and subject to error.

Key challenges

  • Ensuring that replication has been successful, before problems arise.
  • Reducing the amount of time taken to perform checks.

How we can solve it

Following replication, use SQL Data Compare to compare the data in the publisher database with the data in the subscriber database:

  1. Select the databases, then select the tables for which the data should have been replicated, and compare them.
  2. View the results of the comparison, and optionally generate a report of the differences.
  3. If necessary, you can then synchronize any data for which replication has failed.

To learn more, take a look at our worked example.

If required, you can use the SQL Toolkit to schedule the comparison check into a nightly task:

  1. Create a script to execute SQL Data Compare™ on the databases.
  2. Add a scheduled task to run the script using the Windows Scheduled Task Wizard.

You can gain even more flexibility by using the SQL Toolkit™ to create an application, which you can run within your own programs, if required.

Benefits of our solution

  • Automates a painstaking procedure, eliminating human error and saving time.

Online help