Top Rated SQL Compare Alternatives
28 SQL Compare Reviews
Overall Review Sentiment for SQL Compare
Log in to view review sentiment.
Intuitive interface which walks you through table selection and deployment options. Review collected by and hosted on G2.com.
The tool could use better error-handling, especially when a SQL script throws an error and the results include the entire deployment results up to the point of the error. Review collected by and hosted on G2.com.
Installation was fairly quick and easy.When I first launched SQL Compare 9.0, I was presented with a dialog box that was intuitive and simple to use. I was able to immediately start comparing databases, with no steep learning curve to overcome. The results of the comparison seemed straightforward and easy to understand at first Review collected by and hosted on G2.com.
As I got further into the process, I had difficulty figuring out how to perform certain actions. One problem I had was getting past the errors for the full-text indexes. Full-text indexes weren’t listed in the object list in the output. I removed full-text catalogs from the output via the filters, but this had no effect on the output. I eventually figured out that you can select to ignore full-text indexes as a project option and that there’s no other way to remove full-text indexes from the results. Changing the project options means rerunning the comparison to get a new set of results. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
It's a really powerful tool. We used since 7 years SQL Compare and SQL Data compare. We've used with sql server 2005, 2008, and now with sql server 2012. It's useful the object filter (choose only, for example, role, stored procedures, functions, tables, etc...), great the 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 it's a little bit messy, but you can fix it in an easy way by setting the options (also for the project). sometimes you could get an error if you have some linked server in your stored procedures or function or some transaction, there are hints about that on the web (setting up transaction isolation level read uncommitted, and so on...) Review collected by and hosted on G2.com.
Ease of use, immediate result.
I use this software everyday, with this you can compare different tables, storeds and SQL objects, discovering easily the differences and findout an immediate solution regarding the alignment of SQL servers. Review collected by and hosted on G2.com.
The only hassle is having to buy a new license if you are comparing SQL Server environments more updated than the one used. For example, if you have the version of 2008 you can not compare a table SQL Server 2008 with another table SQL Server 2012. Review collected by and hosted on G2.com.
I love how easy it is to use to find differences between databases. The ability to create scripts to update one database to another is great. There are so many options to choose - whether to sync everything, just table differences, procs, views, etc. The "ignore" list makes it simple to determine what you want to include in the compare. Review collected by and hosted on G2.com.
I haven't found anything I particularly dislike. Review collected by and hosted on G2.com.
