Migration

12 Aug 2006 12:22 PM

Ed

Can someone please tell me how to migrate system DBs from 00 to 05? I
unstand I can use detach / attach or backup / restore for all user databases.
I am now sure to to do the Master and MSDB (Including all the Jobs and DTS
Packages)..

Thanks

Ed

12 Aug 2006 2:01 PM

ML

Have you tried the upgrade advisor?
http://msdn2.microsoft.com/en-us/library/ms144256.aspx

ML

---
http://milambda.blogspot.com/

12 Aug 2006 2:34 PM

Tibor Karaszi

The only automated upgrades I know of for system databases is to let the setup program upgrade the
whole instance...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Ed" <E*@discussions.microsoft.com> wrote in message
news:FA40121B-DC90-4ACA-AB6E-913BA757C926@microsoft.com...
> Can someone please tell me how to migrate system DBs from 00 to 05? I
> unstand I can use detach / attach or backup / restore for all user databases.
> I am now sure to to do the Master and MSDB (Including all the Jobs and DTS
> Packages)..
>
> Thanks
>
> Ed