Moving a database from 2000 to 2008

Last Post 07 Nov 2011 06:09 AM by dbandee. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

14 Jul 2011 08:30 AM

I've successfully been able to use the "Move Database" wizard in 2008 to pull in some older 2000 databases.

The only problem I've encountered so far is the SQL user it copies over is disabled in the new database. I have to go into the user properties to "enable" the user account in SQL 2008.

Is this behavior by design?


New Member
New Member

07 Nov 2011 06:09 AM
I think it is .I remember seeing something similar like you mentioned.
I always use backup and restore method and then manually cleaned up and synched all the logins.
What i do i generate backup tsql command for all dbs i want to copy over and also restore command

Acceptable Use Policy