SQL Data Compare
Walk-through 1: Using SQL Data Compare
This walk-through will show you how to:
- Set up a comparison
- Understand the comparison results
- Include a backup prior to synchronization
- Confirm synchronization
Stop walk-through
Step 10: View warnings, action plan and SQL script
The next screen in the Synch Wizard allows you to view the SQL Script that SQL Data Compare has generated and that will be executed in order to synch the two databases. It also provides two different summary reports, identifying a) the order of actions in the synchronization script and b) the changes grouped by object, as well as a tabbed set of warnings about any slowdowns that may be encountered when synchronizing. Either summary can be saved for version control purposes by right-clicking it.





