Moving a database from 2000 to 2008

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

--
14 Jul 2011 09: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?


Thanks!

dbandee
New Member
New Member

--
07 Nov 2011 07: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
---