Migrate MSDB from SQL7 to SQL2K

[bokon]

Hi,

I'm migrating one of our servers from SQL7 to SQL2K. I plan on DTSing the user databases from the SQL7 server to the new SQL2K server. However, I'm a bit stumped regarding MSDB. Detach/Attach won't work, DTS won't move the sys* tables, etc.

Does anyone have a snappy way of moving all scheduled jobs, DTS packages, etc. from one MSDB to another?

Thanks!
-Brian

[skhanal]

You can generate scripts for all jobs by selecting them in job list and right clicking and selecting generate scripts.

You can run this script in your new server.