mssql beyond compare tool?

is there a mssql2k beyond compare tool? i have a failing server with tons of crap on it. 1% free space. need to move old back ups, create new backups, then migrate them... i need to move the databases to a newer server. but they have about 45% overlap in database names. so looks like the previous developer was in the process of migrating every thing, but thta didnt get completed and there is no documentation.. so is there a tool i can use to analyze differences. man.. i am so sqrewd.. any help would be beautiful.. -paul.

it's expensive at $595 for the bundle, but RedGate's SQL Compare and SQL Data Compare are top-notch and well worth it. http://www.red-gate.com/Products/index.htm ----- Excess quoted text cut - see Original Post for more -----

+1 for the RedGate tools. They are *unbelievably* useful if you're thrown in with lots of poorly documented MSSQL databases or just problems. ----- Excess quoted text cut - see Original Post for more -----

thanks a bunch guys for the recommendation. downloading toolkit 14 day trial.. hopefully it will help. i need to come up with a migration plan.. so much fun playing doctor when i have a new site that needs to be out mid june..

Ditto the +1 on RedGate. On Tue, May 20, 2008 at 10:28 AM, John Paul Ashenfelter < john.paul.ashenfelter@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

----- Excess quoted text cut - see Original Post for more ----- Paul, check out xSQL Software's (http://www.xsqlsoftware.com) xSQL Object for comparing and synchronizing database schemas (structure) and xSQL Data Compare for comparing and synchronizing the data - you may not have to pay anything at all - check this for a description of how we license our products: http://xsqlsoftware.blogspot.com/2008/04/unique-hassle-free-software-licensing.html   

I think that apex software has a tool that does this. N ............................................................................ ..... Nick Gleason | CitySoft, Inc. | http://www.citysoft.com Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less >> Do More - Community Enterprise combines great features with an affordable price. ............................................................................ ..... ----- Excess quoted text cut - see Original Post for more -----

We use "redgate"... It's a commercial tool but quite powerful. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com ----- Excess quoted text cut - see Original Post for more ----- Paul, check out xSQL Software's (http://www.xsqlsoftware.com) xSQL Object for comparing and synchronizing database schemas (structure) and xSQL Data Compare for comparing and synchronizing the data - you may not have to pay anything at all - check this for a description of how we license our products: http://xsqlsoftware.blogspot.com/2008/04/unique-hassle-free-software-licensi ng.html    

I use ApexSQL, it's cheaper I believe then RedGate's tools and just as powerful I believe.  They do have a few bugs in some of the later versions, but I haven't had any data loss due to them, only have had to modify some queries that it generates. Russ ----- Excess quoted text cut - see Original Post for more -----