user / security migration

20 Nov 2006 10:29 AM

Pablo Cognito

Hi,

1) is there a migration tool for migrating users from ss2000 --> ss2005?
What about security on databases?

2) is there a migration tool for migrating jobs made in ss2000 --> ss2005?

20 Nov 2006 1:16 PM

Joel Maslak

>>> On Mon, Nov 20, 2006 at 3:29 AM, in message

<uoiPS7IDHHA.4***@TK2MSFTNGP04.phx.gbl>, Pablo
Cognito<pcogn***@gmail.com> wrote:

> 1) is there a migration tool for migrating users from ss2000 -->
> ss2005?
> What about security on databases?

I used and modified some scripts I found online for this.

See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

> 2) is there a migration tool for migrating jobs made in ss2000 -->
> ss2005?

I did that "manually". I scripted each job on the source server and ran
the scripts on the target server. But I only had a handful of jobs on a
few servers.