March 7, 2003 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/migratingtoanewservermovinglogins.asp
March 10, 2003 at 4:42 am
I have yet to get the 2K DTS method to work yet, but then I was following the online help which is self-contradictory on this :(. As for the scripted version (good for 7 & 2K) I have to say the MS script provided in the KB article is inadequate as it doesn't script the server level permissions for the logins or the default dbs. I have an amended version of the script that does these tasks if anybody's interested. Although I should add the caveat that it's only been "developer tested" :P.
March 10, 2003 at 10:05 am
I've gotten the 2K-2K to work, but not 7 to 2K.
The stored procedure is intended to move logins, not permissions, though I agree with you that adding permissions would be nice. Since very, very few logins have server permisions, not too concerned about this.
As far as default dbs, the dbid can change, so resetting these is something that might need to be done anyway.
IF you've got a script, please post it in the script library (with carveats). I'm sure some people would like to see it.
Steve Jones
July 14, 2011 at 11:15 am
once we transfer using this, are we able to find this login in old SQL server? What if we are doing side-by-side upgrade and for some reason if migration fails and i want to run my old sql server again, do i have to transfer all login back?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply