March 5, 2008 at 7:18 am
Hello,
First of all, I am far from an expert on SQL Server, but I have been asked to perform an upgrade of SQL server from 2000 SP4 (8.00.2039) to 2005.
Before even buying the software I downloaded the 2005 Upgrade Advisor from Microsoft and ran it on the server, amongst other things, I got the following problems that need to be solved before upgrading to 2005:
* SQL Server 2000 Meta Data Services packages are not supported.
- Here I installed 2000 client tools, because I got the idea that would help, when rerunning Upgrade Advisor, I still have the same problem listed.
* SQL Server 2000 DTS Designer components are required to edit DTS packages
- I downloaded the DTS Designer Components which are installing stopped Enterprise Manager from working, I googled that and found reinstalling SP4 for version 2000 would help, I did that and now Enterprise Manager runs fine. But I am still getting that "...Designer Components are required..." when running the 2005 upgrade advisor.
So what can I do now? Do I really need to worry about the two above problems at all?
Any other tips, hints or pointers in general about upgrading from SQL Server 2000 to 2005 would also be greatly appreciated.
Thank you,
Challe
March 5, 2008 at 9:27 am
Those two messages are generated every time you run Upgrade Advisor, regardless of whether you have packages stored in MetaData Services or have DTS Designer components installed.
If you don't store packages in MetaData Services don't worry about the first message. If you do store packages there, you'll have to store them in SQL Server i.e. msdb.
You'll have to install DTS Designer components on the server only if you uninstall SQL Server 2000 and if you plan to keep DTS packages as legacy packages rather than migrate them to SSIS. It seems most shops, including mine, with more than a couple of packages keep the DTS packages and migrate to SSIS over time.
Greg
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply