Sunday, March 11, 2012

Database Diff?

Are there any tools/utilties that can diff 2 sql server databases. I know the DB Pro Edition of VSTS can do it, but its hard to justify a jump from my $800 copy of VS2005 Pro to a $5k-6k version of VS just to get database diff. The tablediff looks promising but I need it to do SPROCS and SFUNCS too. Any helps or recommendations would be appreciated.

You might give Redgate SQL Compare a try.

http://www.red-gate.com/products/SQL_Compare/index.htm?gclid=CMCczdPZx4wCFQlQWAod_HLZaw

|||ApexSQL's Diff tool is also quite good and not very expensive. (www.ApexSQL.com)|||Thanks. They both look good!

No comments:

Post a Comment