A collection of articles covering SQL data compare topics
Advanced comparison
- How to compare SQL Server database tables with different names
- How to narrow a data comparison to affected rows only
- How to recover only individual rows from backups
Comparison automation
- Automatically compare and synchronize SQL Server data
- Automatically comparing and synchronizing data changes in a SQL Server database
- How to automatically compare and synchronize a shared SQL script folder with SQL Server database data
- How to automatically compare and synchronize multiple databases on different SQL Server instances
- How to automatically pull data from a shared script folder to a SQL Server database
- How to automatically synchronize the data in two SQL Server databases on a schedule
- How to compare and synchronize databases programmatically
Continuous integration
Migration
- How to migrate a SQL Server database to a newer version of SQL Server
- How to synchronize large SQL Server databases
- Synchronize SQL Server databases in different remote sources
- How to synchronize specific rows on a SQL remote database using a database installer package
Recovery
- Multiple SQL Server data recovery options
- Recover deleted SQL data from a backup or from online database files
Restore
- How to restore a SQL Server database backup to an older version of SQL Server
- Restore only specific data from SQL backups
Source control
- How to apply static data under source control to a SQL Server database
- How to commit and/or update SQL Server database static data to a source control repository
