Copying users from one server to another.

[tlaksh]

I have a question regarding copying users from one server to another that are running different versions of Microsoft Sequel Server.

I have Server A running 6.5 version and Server B running 7.0 version.

How can I copy just the list of users from Database1 in Server A to Database2 on Server B.

Can anyone help me.

Thanks.

Lakshmi.

 

[Bernadette]

Hi There Lakshmi

How about generating sql scripts in SQL Server 6.5 for the logins and users and then running the scripts on the SQL Server 7.0 machine. Remember though if you use "Generate SQL Scripts" to script the logins, the passwords may be NULL.

Hope this helps
Bernadette

 

[tlaksh]

Thanks ...Bernadette..It worked..

Lakshmi