A collection of articles covering SQL compare and diff tool topics
Comparison automation
- Automatically comparing and synchronizing SQL Server database schema changes
- Compare SQL Server database schemas automatically
- How to automatically compare and synchronize multiple databases on different SQL Server instances
- How to automatically keep two SQL Server database schemas in sync
- How to compare and synchronize databases programmatically
- How to automatically compare and synchronize SQL Server database objects with a shared script folder
- How to automatically pull SQL Server database objects from a shared script folder to a local database
- SQL Server bulk copy and bulk import and export techniques
- How to synchronize large SQL Server databases
Continuous integration
Migration
- How to migrate a SQL Server database to a newer version of SQL Server
- How to build a SQL database directly from scripts
- How to check whether you can safely deploy to production database
- How to create a SQL database build script directly from a backup
- Create a database script from a backup without restoring it
- Remote database synchronization using a database installer package
Recovery
- 4 techniques for recovering lost tables due to DROP Table operation
- How to recover only objects from SQL Server database backups
- How to recover a specific dropped object
Restore
“Smart” data dictionary creation
Host integration comparison
Rollback changes
- How to version and audit schemas and rollback changes with schema snapshots
- How can I take nightly snapshots of SQL server database schema without having to use version control?
Source control
- Getting a database under version control: How to link a database to source control and initially commit objects
- How to automatically monitor a SQL Server database for schema changes and create an audit log in source control
- How to deploy changes directly to a SQL database from a source control repository
- How to deploy object changes directly from a SQL source control label
- How to keep a source control repository updated with the latest SQL Server database changes
- How to work with SQL database source control labels
- SQL Server database continuous integration workflow SYNC step – Creating the synchronization/migration script
- 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
- How to automatically synchronize SQL Server database schema changes to a source control repository
