<div>
I very much doubt you could transfer a system table from one version to another... but I've been wrong before! Better to script out the objects you want to move over.<br />
<br />
In SQL 2005 there is a dts import utility which will attempt to convert your DTS packages into SSIS packages.
</div>


I very much doubt you could transfer a system table from one version to another... but I've been wrong before! Better to script out the objects you want to move over.

In SQL 2005 there is a dts import utility which will attempt to convert your DTS packages into SSIS packages.

<div>
yes &nbsp;I saw it, an utility to import DTS to SSIS but how about the msdb db? as we know that msdb use to stored alert and notification and I have a lot of jobs running and need this db to be transfer as well
</div>


yes  I saw it, an utility to import DTS to SSIS but how about the msdb db? as we know that msdb use to stored alert and notification and I have a lot of jobs running and need this db to be transfer as well

<div>
<div class="content wysiwyg-content">
Hi,<br />
I'm thinking of how do I migrate the system db (msdb) from sql200 to sql2005 I try with copy database wizard in sql2005 but there is no option for me to copy or transfer the db, and one more thing, I also need to transfer\migrate my dts package from sql2000 to sql2005 but not too sure how to work on this
</div>
</div>


Hi,
I'm thinking of how do I migrate the system db (msdb) from sql200 to sql2005 I try with copy database wizard in sql2005 but there is no option for me to copy or transfer the db, and one more thing, I also need to transfer\migrate my dts package from sql2000 to sql2005 but not too sure how to work on this

Migrate msdb from sql2000 to sql2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.