Re: (ot) Database comparison software

2009-05-16 Thread Mike Chabot
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 t

Re: (ot) Database comparison software

2009-05-16 Thread John M Bliss
Right. Plus the latest version will also auto-save that generated code to, say, [project root]\trunk\sql where it can then be checked-in to SVN. On Fri, May 15, 2009 at 8:21 PM, Jason Fisher wrote: > > +1 for Red-Gate's SQL Compare and Data Compare. Not only finds the > differences, but one c

Re: (ot) Database comparison software

2009-05-16 Thread Tom McNeer
What they said. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Want to reach the ColdFusion community with something they want? Let them know on the Ho

RE: (ot) Database comparison software

2009-05-16 Thread Paul Giesenhagen
...@houseoffusion.com] Sent: Friday, May 15, 2009 6:38 PM To: cf-talk Subject: (ot) Database comparison software 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

Re: (ot) Database comparison software

2009-05-15 Thread Jason Fisher
+1 for Red-Gate's SQL Compare and Data Compare. Not only finds the differences, but one click to generate the code to go from either version to the other version. Very handy. ~| Want to reach the ColdFusion community with som

Re: (ot) Database comparison software

2009-05-15 Thread John M Bliss
Cannot recommend the following enough: http://www.red-gate.com/products/SQL_Compare/ It's amazing. And, while you're at it, get this one for data: http://www.red-gate.com/products/SQL_Data_Compare/ Great software. On Fri, May 15, 2009 at 6:38 PM, Michael Dinowitz < mdino...@houseoffusion.com>

(ot) Database comparison software

2009-05-15 Thread Michael Dinowitz
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