Red-Gate SQL Compare is considered to be the best. I've been using it for many years and it is an essential part of my work flow, along with Beyond Compare. The Quest and Apex products are also popular. You can see a more complete list here: http://www.mssqltips.com/tip.asp?tip=1069
The license terms for the Red-Gate tool suite are the same as the Beyond Compare license terms in that it is licensed to the individual, so you only have to buy one license for all your computers and virtual machines. -Mike Chabot On Fri, May 15, 2009 at 7:38 PM, Michael Dinowitz <mdino...@houseoffusion.com> wrote: > > When I have to compare two directories of code, I use beyond compare. It > shows me the differences on a macro and micro level. Now if I wanted to do > the same with with a SQL server, what would I use? I want to compare the > format of two databases and see if there are any differences in the tables. > I could do a 'hack' and generate a script for each DB and then compare them > but there must be something a little cleaner. > Thanks > > -- > Michael Dinowitz (http://www.linkedin.com/in/mdinowitz) > President: House of Fusion (http://www.houseoffusion.com) > Publisher: Fusion Authority (http://www.fusionauthority.com) > Adobe Community Expert / Advanced Certified ColdFusion Professional > Si, soy el senor "chico malo" para ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4