Top Rated SQL Compare Alternatives

Marketing Automation Corp

(64)

4.8 out of 5

Visit Website

SQL Compare Reviews & Product Details - Page 2

admin

SQL Compare Product Details

Claimed

Redgate creates ingeniously simple software to help data professionals get the most value out of any database, anywhere, through the provision of end-to-end Database DevOps. More than 200,000 people globally, including 92% of the Fortune 100, trust Redgate to deliver ingeniously simple software. 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 is the fastest way to compare and deploy SQL Server schemas. It enables yo to find and fix errors, and create deployment scripts in minutes. Find out more about SQL Compare: https://www.red-gate.com/products/sql-development/sql-compare/

Seller

Redgate Software

Discussions

SQL Compare Community

Languages Supported

English

Product Description

SQL Compare makes comparing databases simple and fast. Create scripts to deploy differences or changes to databases.

Overview by

Tey Peryie

SQL Compare Media

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

Compare SQL Server database schemas, large or small, and including Temporal Tables, 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 ...

SQL Compare Demo - 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.

SQL Compare Demo - 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 run deployments directly from the UI or command line, save deployment scripts for later use, or automate your deployments using SQL Change Autom...

SQL Compare Demo - 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.

G2 reviews are authentic and verified.

Here's how.

Verified User in Retail

Mid-Market (51-1000 emp.)

11/7/2018

"Indispensable"

5/5

What do you like best about SQL Compare?

Wonderful software for keeping the schema of your databases in sync. I could not do without. I tried but my databases got out of sync very soon. I love generating the scripts from SQL Compare and then uploading them on the live machines and deploying them. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

It could do without bugs. Some bugs when you save change scripts, but nothing deal-breaking. Also, would be nice to have sequential naming for the files - I have to manage the naming myself. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Compare:

You should really get Data Compare too. They work together. And also Source Control. In fact, you should get the SQL Toolbox if you can afford it. Review collected by and hosted on G2.com.

What problems is SQL Compare solving and how is that benefiting you?

Keeping my database schemas in sync across servers - development, staging and live. I need to maintain about 50 websites, internationally, and they all use the same database schema. Keeping this up to date across platforms would be a pain. Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising

Small-Business (50 or fewer emp.)

1/15/2019

"great way to compare databases"

4.5/5

What do you like best about SQL Compare?

seeing whats different about different databases easily Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

that you need to have premium package in order to compare to github repository even though i paid for sql source control from same company Review collected by and hosted on G2.com.

Joe C.

Lead Database Administrator

Information Technology and Services

Mid-Market (51-1000 emp.)

12/27/2017

"Best one of comparison tool"

4.5/5

What do you like best about SQL Compare?

The variation from point and shoot comparisons with all of the default options to getting very specific with filtering.

Often times it is very useful to be ale to remove items such as user permissions but if that is what needs comparing, then the granularity is great Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Little bit clunky to use as a tool for a many to many scenario where you don’t have a known good baseline to work from. Review collected by and hosted on G2.com.

Verified User in Automotive

Enterprise (> 1000 emp.)

1/31/2018

"Excellent tool for Data comparision"

5/5

What do you like best about SQL Compare?

This is the best tool in industry that I've came across till date, as it makes life simpler in many complex situations. RedGate is very easy to use, easy to compare the data between two Databases, even at table level and the best part is that it even generates scripts for the data difference found, so that Data can be synchronized just by running those scripts. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Nothing that I dislike regarding this tool, except that the license cost is little high which I personally felt. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Compare:

I would recommend 10/10 Review collected by and hosted on G2.com.

What problems is SQL Compare solving and how is that benefiting you?

It is mainly used in situations where data is corrupted or deleted, or when replication has issues and when a snapshot cannot be applied, data can be compared with RedGate, and the difference can be synchronized with the Scripts generated, hence eliminating the need for Snapshot application. This helps especially when the Publication Database/Tables are huge. Review collected by and hosted on G2.com.

Mohit S.

Senior Software Engineer Technical Lead

Enterprise (> 1000 emp.)

1/12/2018

"Great tool to compare and deploy database scripts"

5/5

What do you like best about SQL Compare?

It does a great job of comparing database difference and generating a visual report of the same. You can then generate a script of the changes. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

It does not work seamlessly with DLM automation as a part of the SQL toolbelt. The errors are not intuitive when working on DLM, and it need DBO access to the database, not just read/write. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Enterprise (> 1000 emp.)

4/30/2018

"Great Comparison Tool"

4/5

What do you like best about SQL Compare?

Easy to use interface and returns reliable search results Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Can take a while to load up when first using Review collected by and hosted on G2.com.

Verified User in Financial Services

Mid-Market (51-1000 emp.)

4/5/2018

"Handy tool"

4/5

What do you like best about SQL Compare?

A simple GUI to compare data between two environments was very cool and useful Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

The interface could be better but otherwise no major complaints Review collected by and hosted on G2.com.

Verified User in Banking

Enterprise (> 1000 emp.)

1/17/2018

"Saving time on dB migrations"

5/5

What do you like best about SQL Compare?

Ease of use, scripting possibilities, multiple. Type of sources: live dB, backups, source control... Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

The output of all the data discrepancies is not that trivial in its interpretation; would I do better? Hardly. :/ Review collected by and hosted on G2.com.

Barbara R.

President/Co-Founder

Small-Business (50 or fewer emp.)

4/18/2017

"Excellent tool for comparing databases"

5/5

What do you like best about SQL Compare?

It's a really powerful tool. I have used it for about 6 years SQL Compare and SQL Data compare. I've used with SQL server 2005, 2008, and now with SQL server 2012. It has a useful object filter for the role, stored procedures, functions, tables, etc..., find function and the deployment wizard, that bring you out the script to upgrade/etc your target database/tables/etc. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Sometimes the script is messy and you need to examine it before you deploy. Also, it doesn't alway catch if there is are key constraints. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

10/13/2017

"Industry Leading Software"

3.5/5

What do you like best about SQL Compare?

Very easy to compare similar databases and find differences between records. It seems like almost very scenario is covered. Review collected by and hosted on G2.com.