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 9: Include backup operation in synchronization SQL script
You are then offered the option of inserting a backup procedure at the head of your synchronization script. This can be either a native SQL Server backup or using the additional compression and encryption features of Red Gate SQL Backup.





