SQL Compare Reviews & Product Details

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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

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

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

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

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

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.

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.

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.

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.

I can not think of anything that I dislike about this software. Review collected by and hosted on G2.com.