August 19, 2005 at 2:51 pm
... check the objects of purportedly the same DB in two different instances of SQL Server to see if the objects in both match? We just created a DB on a new machine and then used a backup created on the original machine to restore the complete DB to the new machine. I now want to check the SPs, views, etc. to be sure all the objects migrated to the new DB. I'd rather automate that comparison, if there is some easy way do so, rather than eyeball it.
RichLich
August 19, 2005 at 3:09 pm
It's a little more involved than that. If you did a back-up and restore, then
a. It was not necessary to create the DB beforehand (but no harm done 🙂
b. All items IN that database are guaranteed to be identical, but items that are not in the DB (logins, master database SPs, items in MSDB) will not be
All the details are at
August 19, 2005 at 3:22 pm
Well, I had some "challenges" with DB names being different between the instances. Actually, on the restore, this newbie finally figured out he could rename the DB to the correct name in the new instance.
Master had already been replicated, but this is probably going to be a "customized solution" anyway since the DB in question is attached to Great Plains accounting system.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply