Login transfer from 6.5 to 2000

Question

Login transfer from 6.5 to 2000

Eoin The Forge

SSCrazy

Points: 2932
More actions
March 11, 2004 at 3:44 am

#161110

Hi - I'm upgrading a server from 6.5 to 2000 and want to generate a script (or DTS) to bring the users across with their passwords intact. Any ideas?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jeff W SSCertifiable Points: 5207 More actions · Answer 1

http://support.microsoft.com/default.aspx?kbid=246133

Not sure if this will work with 6.5. I am guessing that it will. I have used this process from Microsoft many of times when migrating. I prefer to script everything out.

"Keep Your Stick On the Ice" ..Red Green

Eoin The Forge SSCrazy Points: 2932 More actions · Answer 2

Thanks Jeff - I've tried it and due to Different Schema etc it's not working. It's a day of typing for my I fear

Sopheap Suy SSCertifiable Points: 7893 More actions · Answer 3

Have you though of the old fashion bcp. It's been a while since I do 6.5 to 2000, but I am sure that's what I did. sql 6.5 use syslogins, but sql 2000 has a table call sysxlogins, they are the same but the name is different. In sql 2000 there is a view call syslogins that pull data from sysxlogins.

mom