Tuesday, March 27, 2012

Exporting Logins

I need to move a database to a new SQL Server. I would like to make it easie
r
to move the Logins from the old server to the new server so that a
backup/restore will allow the database to get up and running with minimal
effort.
Since you can script just about anything, I was looking for a way to script
the Logins to facilitate their movement? Is there such a process? Is there a
different or better way to move the Logins to another SQL Server (2005)?
--
Michael HocksteinHi Michael..
You can take a look in the post " how to transfer logins between 2k5
instances" a few threads ago. Also you can check
http://support.microsoft.com/defaul...kb;en-us;246133
Regards
Antonio Soto
Solid Quality Learning
"michael" <howlinghound@.nospam.nospam> escribi en el mensaje
news:4E518423-6E53-4D30-B059-D8BC1FD23E3D@.microsoft.com...
>I need to move a database to a new SQL Server. I would like to make it
>easier
> to move the Logins from the old server to the new server so that a
> backup/restore will allow the database to get up and running with minimal
> effort.
> Since you can script just about anything, I was looking for a way to
> script
> the Logins to facilitate their movement? Is there such a process? Is there
> a
> different or better way to move the Logins to another SQL Server (2005)?
> --
> Michael Hockstein|||Thanks. Sorry I missed a post that was literally under my nose.
Michael Hockstein
"Antonio Soto" wrote:

> Hi Michael..
> You can take a look in the post " how to transfer logins between 2k5
> instances" a few threads ago. Also you can check
> http://support.microsoft.com/defaul...kb;en-us;246133
> Regards
> Antonio Soto
> Solid Quality Learning
>
> "michael" <howlinghound@.nospam.nospam> escribió en el mensaje
> news:4E518423-6E53-4D30-B059-D8BC1FD23E3D@.microsoft.com...
>
>sql

No comments:

Post a Comment