How to transfer user logins between to SQL Servers

Commands, SQL No Comments

Hi !

If you are installing a new SQL Server and would like to transfer the logins from an old SQL Server, without doing a SQL restore, then you can do it with a script.

Take a look on this article How to transfer logins and passwords between instances of SQL Server; here Microsoft describes how to do it.

Basically it is a 2 part step. First you export the current user informations from the old server and then afterwards you run a create script on the new server. The detailed scripts can be found in the article from Microsoft :-)

Leave a Reply

Icons by N.Design Studio. Designed By Ben Swift and Customized by Ingrid Byllemos. Powered by WordPress
Entries RSS Comments RSS Log in