How to compare multiple db versions

[RandyBlackburn]

I'm trying to update the production version of a db with changes made to the developent version. At the moment, I'm trying to use a utility called "DatabaseComparer" but I'm running into a problem: the database names and filenames are, of course, identical.

My approach has been to copy and rename the files, but apparently, the copies are not recognized as sqlserver files.

What is the best approach ... I'm sure you guys do this all the time, but I'm a newbie.

Thanks in advance,
Randy

 

[mrdenny]

Do a backup and restore using the MOVE paramater to rename the physical files. Be sure to restore to a different database name.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[RandyBlackburn]

Denny,

Thanks for the response.

What tool do you use to to this? What's the format of the move command?

Randy