April 8, 2009 at 3:28 pm
I am trying to upgrade a SQL 2000 server to SQL 2005. I have ran the upgrade adviser and got the following task that need to do first:
1) SQL Server 2000 Meta Data Services packages are not supported
2) SQL Server 2000 DTS Designer components are required to edit DTS packages
And after upgrade:
1) SQL Server 2000 Data Transformation Services is deprecated
2) Upgrade Advisor reports only on the most recent version of each DTS package.
Any one can suggest me how I can perform the above task and what I need to do before I upgrade to 2005. Or what is the good method to upgrade 2000 to 2005.
Thank you,
Haider
April 8, 2009 at 4:17 pm
biswas4444 (4/8/2009)
I am trying to upgrade a SQL 2000 server to SQL 2005. I have ran the upgrade adviser and got the following task that need to do first:1) SQL Server 2000 Meta Data Services packages are not supported
upgrade advisor always says that. Only a problem if you actually have meta data packages
2) SQL Server 2000 DTS Designer components are required to edit DTS packages
to be able to edit your dts packages you need to download and install the sql 2000 DTS designer components after the upgrade:
then you can continue with DTS until you get time to migrate them to SSIS
And after upgrade:
1) SQL Server 2000 Data Transformation Services is deprecated
2) Upgrade Advisor reports only on the most recent version of each DTS package.
see above URL.
what is the good method to upgrade 2000 to 2005.
two basic methods, in-place or side by side. Lots of articles on that, search on upgrading SQL 2000 to 2005
---------------------------------------------------------------------
April 8, 2009 at 4:24 pm
Sorry bad advise, Edited....
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply