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. 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.

• How To Use Redgate Data Compare

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: (last two as a bundle) They are far cheaper than Red Gate's stuff--just not sure if capable enough. Thanks for any suggestions. We are actually only licensed with VS up to 2010, but I was digging around because I actually did see the SQL Server Data Tools and it mentioned and seemed to indicate that it worked fully even in the Express versions of VS.

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. Database-comparison sql-database-comparison. Red Gate Sql Compare (sometimes referred to as Sql Compare) was added by cardguy1000 in Sep 2013 and the latest update was made in Nov 2014. The list of alternatives was updated Dec 2018 There is a history of all activites on Red Gate Sql Compare in our Activity Log. Red Gate's SQL Compare is a product I have used for years and I love the latest version. Above, I mentioned a sister product called SQL Data Compare. It works in much the same way but instead of comparing schemas, it compares table content.

How To Use Redgate Data Compare

I downloaded VS 2013 Express onto my machine and started poking around at it and let one of our developers look at it. She can't really fully dive into it until tomorrow, but some initial compare things we messed with got her a bit excited about it. Ultimately they have to say if it does what they want or not, but given how basic our needs are--this would be fantastic if it works. Thanks for the reiteration of it and heads up. We're going to run this through the paces as I like the idea of free--especially at the cost of Red Gate SQL compare per developer. Even if we only use VS 2013 Express for SQL schema and data compare, this will be a big money savings.