SQL Server migration from 2000 to 2008

  • Follow


I have a project to migrate sql server 2000(in old server) to sql server
2008 (in new server)
I have a rough try and found User Databases can be restored to sql server
2008. I also found some articles about moving Logins account.

But we also have many DTS, scheduled jobs and System Databases.

How can i migrate these components too? As SSIS is a totally new thing and i
hope ideally i won't need to convert all DTS.

Thanks all experts.



0
Reply thomas 4/14/2010 3:08:59 AM

thomas
You have to save DTSs as structure file (for example) and  the open them on 
SQL Server 2008 under Legacy folder

Please visit on www.sqldts.com  for more info



"thomas" <thomas@mail.com> wrote in message 
news:%23KFxfA42KHA.5588@TK2MSFTNGP06.phx.gbl...
>I have a project to migrate sql server 2000(in old server) to sql server
> 2008 (in new server)
> I have a rough try and found User Databases can be restored to sql server
> 2008. I also found some articles about moving Logins account.
>
> But we also have many DTS, scheduled jobs and System Databases.
>
> How can i migrate these components too? As SSIS is a totally new thing and 
> i
> hope ideally i won't need to convert all DTS.
>
> Thanks all experts.
>
>
> 


0
Reply Uri 4/14/2010 5:46:06 AM


1 Replies
150 Views

(page loaded in 0.021 seconds)

Similiar Articles:
















7/30/2012 2:49:22 PM


Reply: