(ot) Database comparison software

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