Redgate Database Compare
Redgate Sql Compare
Red Gate Sql Data Compare
I am looking for suggestions on an alternative product for comparing SQL schema and data with Microsoft SQL server (2012). Up to this point in time our company has used Red Gate SQL Compare and SQL Data Compare with an older SQL version, and it has worked well. Www.rainbowweddingnetwork.com. The problem is that we need to purchase a new version (no upgrade path) and the product is far more expensive that what we had paid many years back. In looking at some alternatives, I see there are other products out there which are far cheaper. Thankfully, they appear to have trials, so I'll probably nab one or two and let our developers give it a go to see if they live up to expectations.
Does anyone have some personal recommendations of what they've used that would be a good alternative for SQL schema and data compare to Red Gate's product? Right now I'm looking at these:
http://www.devart.com/dbforge/sql/compare-bundle.html
http://www.xsql.com/products/sql_server_schema_compare
http://www.xsql.com/products/sql_server_data_compare
(last two as a bundle)
They are far cheaper than Red Gate's stuff--just not sure if capable enough.
Thanks for any suggestions.
The base for this project is that I’m using TFS for source control, and have my databases checked in using SQL source control from red-gate. I’m using sql schema and data compare version 10.2 to push the changes around. The initial comparison will convince SQL Compare that the database has all the objects, and the scripts folder has none. Ask, discuss, and solve questions about Redgate's tools. Events & Friends. Meet us at an event, get sponsored, and join our Friends of Redgate.