Showing posts with label sync. Show all posts
Showing posts with label sync. Show all posts

Monday, March 19, 2012

Move SQL Users id + pw to new box

I have everything transferred between our older stage server to it's
replacement. Is there a good way to transfer db users?
I have downloaded Sync SQL Logins from
http://www.dbmaint.com/SyncSqlLogins.asp
Is there an alternative someone has used that they like better?
From my first go with this tool, I think that I need to give every pw to
actually move the id?
TIA
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:ezBk71TEGHA.1264@.TK2MSFTNGP09.phx.gbl...
>I have everything transferred between our older stage server to it's
>replacement. Is there a good way to transfer db users?
> I have downloaded Sync SQL Logins from
> http://www.dbmaint.com/SyncSqlLogins.asp
> Is there an alternative someone has used that they like better?
> From my first go with this tool, I think that I need to give every pw to
> actually move the id?
After looking around more on the net I realized that I had the RedGate
bundle and it did what I was interested in achieving. I live in the data
compare almost daily, and forgot all about the SQL compare.
__Stephen
|||Stephen
You can also use DTS as this article explains.
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
Regards
John
"__Stephen" wrote:

> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:ezBk71TEGHA.1264@.TK2MSFTNGP09.phx.gbl...
>
> After looking around more on the net I realized that I had the RedGate
> bundle and it did what I was interested in achieving. I live in the data
> compare almost daily, and forgot all about the SQL compare.
> __Stephen
>
>

Move SQL Users id + pw to new box

I have everything transferred between our older stage server to it's
replacement. Is there a good way to transfer db users?
I have downloaded Sync SQL Logins from
http://www.dbmaint.com/SyncSqlLogins.asp
Is there an alternative someone has used that they like better?
From my first go with this tool, I think that I need to give every pw to
actually move the id?
TIA"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:ezBk71TEGHA.1264@.TK2MSFTNGP09.phx.gbl...
>I have everything transferred between our older stage server to it's
>replacement. Is there a good way to transfer db users?
> I have downloaded Sync SQL Logins from
> http://www.dbmaint.com/SyncSqlLogins.asp
> Is there an alternative someone has used that they like better?
> From my first go with this tool, I think that I need to give every pw to
> actually move the id?
After looking around more on the net I realized that I had the RedGate
bundle and it did what I was interested in achieving. I live in the data
compare almost daily, and forgot all about the SQL compare.
__Stephen|||Stephen
You can also use DTS as this article explains.
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
Regards
John
"__Stephen" wrote:

> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:ezBk71TEGHA.1264@.TK2MSFTNGP09.phx.gbl...
>
> After looking around more on the net I realized that I had the RedGate
> bundle and it did what I was interested in achieving. I live in the data
> compare almost daily, and forgot all about the SQL compare.
> __Stephen
>
>