Red Gate SQL Compare Reviews

Redgate approach to filtering is generally easier to manage.

Redgate scripts do not support SQLCMD variable syntax.

Just use it if you want model based source control solution.

I had a team of 12 members, Sometimes its too heavy load on us to compare huge database objects, this problem is solved with Redgate

It's super fast, accurate, and simple. Saved hours of development using it!

Price is a bit expensive, it should be an option for small business

Try it!

I have a tenant database architecture, and RedGate helps me to compare and share configuration info between all of them.

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.

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.

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.

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.

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.

Nothing that I dislike regarding this tool, except that the license cost is little high which I personally felt.

I would recommend 10/10

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.

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.

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.

Generating automated script for SQL database deployments.

Ease of use, scripting possibilities, multiple. Type of sources: live dB, backups, source control...

The output of all the data discrepancies is not that trivial in its interpretation; would I do better? Hardly. :/

Database migration in mimures

Best available product for this purpose.

Nothing to dislike. Always welcome and excited for updates and new features.

Comparing SQL objects.

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.

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.

Would also recommend SQL Diff and SQL Data Compre

It is a great tool for moving from development to production.

I love the SQL Search feature. When working with large databases it can be hard to keep track of objects when multiple changes are being made by multiple users. The SQL Search Feature lets you search for a column name for example and will show you every instance of where that column name occurs in the database.

So far the product has been meeting my needs and I cant quite pinpoint anything at this point that I do not like as the tasks I have had to complete have been quite simple and I have been able to do them with ease.

A very handy tool for managing migrations. I would recommend using the SQL Compare if you have seperate development, test and production environments. It will make moving data object quite easy

When moving data from a testing to a production environment, the SQL Compare lets you ensure consistency between versions and manages the script creation for that process in a very easy to use manner. It saves the DBA having to write alot of extra code.

The schema compare wizard is really something special.

The cost is a little prohibitive for sole developers.

If you are part of a larger organisation then definetly make the case to buy this from your Management.

We are activly using the product to replicate schema's acros multiple sites and client.