copy users on server to another - SQL 2005 SP2

copy users on server to another - SQL 2005 SP2

am 27.08.2007 18:20:22 von rcamarda

I've built a development server for my SQL 2005 production
environment. I've restore the databases from a backup, and I want to
copy the users from my production to development machine.
How can I do this?
TIA
Rob

Re: copy users on server to another - SQL 2005 SP2

am 27.08.2007 19:35:25 von shiju

One way is to use Transfer Login Task through SSIS
Thanks
Shiju Samuel

On Aug 27, 9:20 pm, rcamarda wrote:
> I've built a development server for my SQL 2005 production
> environment. I've restore the databases from a backup, and I want to
> copy the users from my production to development machine.
> How can I do this?
> TIA
> Rob

Re: copy users on server to another - SQL 2005 SP2

am 27.08.2007 20:30:38 von rcamarda

On Aug 27, 1:35 pm, Shiju Samuel wrote:
> One way is to use Transfer Login Task through SSIS
> Thanks
> Shiju Samuel
>
> On Aug 27, 9:20 pm, rcamarda wrote:
>
> > I've built a development server for my SQL 2005 production
> > environment. I've restore the databases from a backup, and I want to
> > copy the users from my production to development machine.
> > How can I do this?
> > TIA
> > Rob

thanks! that did the trick!