November 20, 2002 at 9:34 am
I am in the middle of scripting datbases and was wondering what is the best way to compare the old database with the newly scripted database. sp_spaceused just doesnt cut it. I want to make sure all my data, indexes, triggers, etc came over properly.
November 20, 2002 at 9:45 am
I use a product call SQL Compare by Redgate. Works very good. Think you can get a 15 day evaluation copy of tool here:
http://www.red-gate.com/downloads.htm
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 20, 2002 at 10:00 am
I have wrote a little app that scripts everything and then I compare the files with sourcesafe. This also means I can check with my stored version of the database
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply