West Virginia Finance

Aug 31 2018

SQL Compare: Compare And Synchronize SQL Server Schemas

#sql #hour


The fastest way to compare deploy SQL Server schemas

71% of Fortune 100 companies use Redgate SQL Compare

Compare SQL Server schema changes from dev, to test, to production

Compare SQL Server database schemas, large and small, with advanced filtering of database objects.

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.

Troubleshoot database differences and create reports in HTML or Excel.

Deploy with zero errors

SQL Compare scripts dependencies in your database in the right order, to make sure deployment is successful.

You get notifications about any issues, such as data loss, before you deploy.

Deploy changes directly

Migrate individual schema differences, a selection of them, or all of them.

Build sophisticated rules to selectively limit what to deploy.

You can automate deployments with the command line, run them from the UI, or save a deployment script and run it yourself.

Find and fix problems in production

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.

Introduction to SQL Compare

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.

Whether you need to deploy changes or explore the differences between two SQL Server databases, SQL Compare helps you do the job quickly, simply, and with zero errors.


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

SQL Data Compare and SQL Compare are two of the most important tools I have in my development operation. I can be so responsive to end-user requests for new features using the tools to deploy upgrades to my SaaS application (which by the way has 100% uptime for the last 7 consecutive months) because of the excellent work by Redgate.

John Pluchino, Application Developer, T-Squared Software Services

100% like the new look and feel. The product is very easy to use and somehow you managed to incorporate a lot of familiarity with the updated look which I think is spot on. Not enough to cause data professionals to go into a panic but enough for us to be wowed.

Chris Yates, DBA Manager, Republic Bank

For the price you pay, you’ll save the equivalent time on your next version release.

Peter Vogel, Visual Studio Magazine

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

Success stories

“We’ve freed up the DBA team by 70-80%. That’s the ROI, and the leadership team can understand that too.”

Read how Republic Bank streamlined database deployments with SQL Compare, cutting down deployment times from one hour and a quarter to less than 15 minutes and freeing up the DBA team by 70-80%.

“The whole of the Redgate family are really reliable tools. It gives you results, you know those results are going to be right.”

Chris Yates, Serge Krasnay, Lindsay Clark, Arthur Daniels, Nick Fry, and Tjay Belt explain how useful they find SQL Compare every day, why they love and trust SQL Compare, and why they’d recommend it to others.

Full list of features

SQL Compare

Written by admin

Leave a Reply

Your email address will not be published. Required fields are marked *