| Author |
Move SQL Users id + pw to new box
|
|
| __Stephen 2006-01-04, 9:23 am |
| 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 2006-01-04, 11:23 am |
|
"__Stephen" < srussell@transaction
graphics.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
| |
| John Bandettini 2006-01-04, 11:23 am |
| 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@transaction
graphics.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
>
>
>
|
|
|
|