logins

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mecn - 29 Mar 2006 17:38 GMT

Hi,

How do I transfer all logins from sql2k server to a new sql2005 box?

Thanks

Reply to this Message

Antonio Soto - 29 Mar 2006 21:47 GMT

You can use many approaches:
- Copy Database Wizard
- A SQL 2000 DTS package
- A SQL 2005 SSIS package

Also you can use the following script
http://solidqualitylearning.com/blogs/antonio/archive/2006/02/25/1618.aspx

Regards

Signature

Antonio Soto
Solid Quality Learning
http://www.sqlu.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

> Hi,
>
> How do I transfer all logins from sql2k server to a new sql2005 box?
>
> Thanks

Reply to this Message

mecn - 29 Mar 2006 22:24 GMT

thanks

> You can use many approaches:
> - Copy Database Wizard
[quoted text clipped - 11 lines]
>>
>> Thanks

Reply to this Message

mecn - 29 Mar 2006 22:24 GMT

Thanks, All I need to do is transfer to master.logins table

> You can use many approaches:
> - Copy Database Wizard
[quoted text clipped - 11 lines]
>>
>> Thanks

Reply to this Message