SQL Compare is the industry standard for comparing and deploying SQL Server database schemas quickly and accurately.
71% of the Fortune 100 use SQL Compare to compare SQL Server databases – because it's relentlessly tested, easy to use, creates flawless deployment scripts, and saves time.
I bless the day we bought SQL Compare - it saves me time so often. Must have paid for itself a hundred times over.
Limited to manual diffs and synching of databasesBuy now
Includes command line support and deployment from source control and backupsBuy now
Sync data, deploy from version control, & more, with all our SQL Server toolsSee what’s included
Remembering the changes you’ve made to a database, working out what your colleagues have done, and scripting it out for deployment is tricky and time consuming.
SQL Compare makes it fast.
You can explore what’s changed in each database object, down to individual lines of SQL. When you’re ready to deploy, you can create an error-free deployment script in minutes.
SQL Compare scripts dependencies in your database in the right order, to make sure deployment is successful.
It also flags up any issues, such as data loss, before you deploy.
To fix errors in your production database, compare it to a backup, scripts in source control, or a database snapshot. You can deploy single objects to fix the issue fast.
If you need to fix static data, use SQL Data Compare to deploy changes without the need for full database recovery.
SQL Compare fits into the development process you prefer.
You can automate deployments with the command line, run them from the UI, or save a deployment script and run it yourself.
For review and sign-off, you can also export a list of changes in HTML or Excel formats.
“I bless the day we bought SQL Compare - it saves me time so often. Must have paid for itself a hundred times over.”
“For the price you pay, you'll save the equivalent time on your next version release.”
“We can create SQL deployment scripts extremely fast and have them ready for a release within minutes of the build being generated. We use SQL Data Compare to sync any system configuration changes, and then we are pretty much ready to go.
Your software is, in a word, awesome. Keep up the great work!”
“SQL Compare has saved us an awful lot of time and code and allowed us to get our version control organised across our 40 data warehouses... Like I said, great product, great value.”
“Just purchased SQL Compare. With the productivity I'll get out of this tool, it's like buying time.”
|What can I compare, synchronize, and deploy?||Standard||Pro|
|SQL Server 2005, 2008, 2012, 2014, SQL Azure, & SQL Server on Amazon RDS databases|
|Snapshots of the schema|
|Backup files (both native SQL Server & Redgate SQL Backup Pro)|
|Folders of SQL scripts (for source control)|
|Compare and deploy changes to SQL Server database schemas (from dev, to test, to production)|
|Compare two SQL Server databases, synchronize, and deploy from within SSMS|
|Automatically create error-free deployment scripts|
|Generate T-SQL scripts that update one SQL Server database to match the schema of another|
|Save deployment scripts for later use|
|Automatically create error-free synchronization scripts|
|Comparison and deployment of large databases|
|Migrate individual schema differences, a selection of them, or all of them|
|Build sophisticated rules to selectively limit what to deploy|
|Deploy individual schema differences, a selection of them, or all of them|
|Support for reading encrypted database objects|
|Fine-grained filtering of database objects|
|Troubleshoot database differences|
|Dependency checking, so objects are scripted in the correct order for updates|
|Warnings about anything you need to be aware of before deploying SQL Server schemas|
|Save schema snapshots for audit and roll-back purposes|
|Create reports in HTML or Excel detailing database differences|
|Troubleshoot database differences and explore schema changes to see what's going on in development|
|Command line automation|
(If you're using the command line on a build server, you'll need DLM Automation)
|Automatically output a database into individual object creation scripts|
|Deploy a live database from a set of SQL object scripts|
|Restore just a single object (or selection of objects) from a backup file|
|Get alerts when SQL Server databases drift using DLM Dashboard|
|Compare and sync SQL Server static data as part of your database deployment with SQL Data Compare|