SQL Compare is the industry standard for comparing and deploying SQL Server database schemas.
71% of the Fortune 100 use SQL Compare – because it's relentlessly tested, easy to use, fast, and saves time.
You can work with live databases, database snapshots, SQL scripts in source control, or backups. SQL Compare helps you compare and deploy changes quickly, simply and with zero errors.
|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|
|Compare, synchronize, and deploy database schemas from within SSMS|
|Automatically create error-free deployment scripts|
|Save deployment scripts for later use|
|Automatically create error-free synchronization scripts|
|Comparison and synchronization of large databases|
|Migrate individual schema differences, a selection of them, or all of them|
|Build sophisticated rules to selectively limit what to synchronize|
|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 prior to synchronizing|
|Save schema snapshots for audit and roll-back purposes|
|Create reports in HTML or Excel detailing database differences|
|Command line automation|
(If you're using the command line on a build server, you'll need the DLM Automation Suite)
|Use fast deployment to bypass the comparison results and manually deploy database schemas from the Project Configuration dialog box|
|Automatically output a database into individual object creation scripts|
|Deploy a live database from a set of object SQL scripts|
|Restore just a single object (or selection of objects) from a backup file|
SQL Source Control and SQL Compare Pro now work together to help you rationalize database deployment without sacrificing control over the change process.
SQL Source Control connects your databases to your existing version control system, making it simple to share development work within SQL Server Management Studio.
When it comes to complex database changes, such as table or column splits, SQL Source Control lets you provide reusable scripts that specify exactly how your changes should be handled.
Your scripts are stored in source control alongside the objects they modify and are applied whenever someone accepts your updates.
Because your changes are stored in a single, central location, with instructions on how to apply them, any team member can deploy, confident that changes will work as intended and that your data will stay safe.
When you're ready to deploy, SQL Compare Pro detects your development changes, along with any scripts that specify how to deploy them.
With source control and manual deployments in place, you also have the groundwork to automate your deployments. To take the next steps, try the DLM Automation Suite, which lets you automate database deployments with your release management tool.
“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.”
Want to improve how your organization develops databases? SQL Compare makes manual deployments quicker and safer, so it’s a great first step. If you want to save even more time and reduce risk further, visit our DLM pages to see how else Redgate can help.
For more process and business benefits, visit our DLM overview.