Compare SQL Server schemas and deploy differences
SQL Compare starts at
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, because it's 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.
SQL Compare compares and deploys schema changes
- Save time comparing and synchronizing SQL Server database schemas
- Eliminate mistakes migrating database changes from dev, to test, to production
- Speed up the deployment of new SQL Server schema updates
- Generate T-SQL scripts that update one SQL Server database to match the schema of another
- Find and fix errors caused by differences between databases
- Compare and synchronize within SQL Server Management Studio
- Deploy to SQL Server databases, SQL Azure databases, or SQL Server on Amazon RDS
Do this and more with SQL Compare Pro:
- Deploy databases from source control
- Compare and synchronize from backups
- Command line automation
- Run SQL Compare on your build server for continuous integration (with the SQL Automation Pack)
For more information on the differences between Pro and Standard, see the features page.
Comparing and deploying a database change
With our full set of SQL development tools you can code fast, collaborate easily, and deploy accurately. Sound good?
A clear path through database deployment
SQL Source Control and SQL Compare now work together to help you rationalize database deployment without sacrificing control over the change process.Video: Getting started with SQL Source Control (3:04)
Control how changes are handled
SQL Source Control connects your databases to your existing version control system, making it simple to share development work within SSMS.
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.
Repeatable, reliable, centralized deploymentVideo: A step-by-step guide through database deployment
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.
Deploy from source control
When you're ready to deploy, SQL Compare detects your development changes, along with any scripts that specify how to deploy them. It includes your scripts in the deployment script it generates, to ensure all your changes are deployed as you intended.
SQL Compare also provides a diagram of the change path and the option to review each script, so you have complete oversight of the updates you're making.
I bless the day we bought SQL Compare - it saves me time so often.
Must have paid for itself a hundred times over.
Bill Geake, Senior Systems Analyst, Phillip Securities Pte Ltd
At GovPartner, we build web-based software for cities to manage their Building, Engineering, Planning, and Code Enforcement projects. We have clients all over the US and just recently went live with our software over in the middle east for the city of Abu Dhabi.
We could not have done it without your tools, specifically the SQL Compare and SQL Data Compare products.
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!
Jon Howes, CTO, GovPartner
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.
Mike Hickin, Touch Clarity Limited
Just purchased SQL Compare. With the productivity I'll get out of this tool, it's like buying time.
Robert Sondles, Blueberry Island Media Ltd
SQL Compare 11 beta
Try the SQL Compare 11 beta for more SQL Server 2014 support, including support for:
- Natively compiled stored procedures
- Clustered columnstore indexes
- Incremental statistics
You can try the beta alongside SQL Compare 10. Let us know what you think, and help us build the SQL Compare you’d like to see.
Got any questions?
+44 (0)1223 437 922
Try SQL Compare
Download a 14-day free trial, and start saving time with your database deployments.