?
Solved

SQL 2000 Upgrade advisor

Posted on 2009-02-24
2
Medium Priority
?
874 Views
Last Modified: 2013-11-30
Hi,

I plan to upgrade our SQL server to the 2005 version.
Running the upgrade advisor, I get the following message (see code below).

WehnI look at the table involved (DocumentIndex), it is empty (0 row). Those that indicates that I don't need to bother about this warning?

I also get a warning regarding the DTS package but I don't know if it can have a consequence after migrating.

thanks for your help on these issues.

Regards,

JBS

FTK
 
Database Server,"PreUpgrade","Increase database size to accommodate DOCID map","
Since the DOCID map in SQL Server 2005 is stored in the database, the size requirement on the database side has increased, but has reduced on the full-text catalog side. If a database contains a full-text index, you need to ensure that the file group associated with the base table has enough space to accommodate the additional space requirement for full-text indexes. Use the following formula to estimate the space required. 
(2*FTK+ 34bytes) * RC 
Where:
FTK = Full-Text Key Size 
RC = Row Count of the Table
,Database Name: XXXl_MSCRM","Table Name: DocumentIndex",
 
 
 
DTS:
 
SQL Server 2000 Data Transformation Services,"PreUpgrade","You can use SQL Server 2005 tools to edit your existing DTS packages. However, upgrading or uninstalling the last instance of SQL Server 2000 on a computer removes the components required to support this feature. You can retain or restore these components by installing the special Web download, ""SQL Server 2000 DTS Designer Components"", before or after you upgrade or uninstall SQL Server 2000.","SQL Server 2000 DTS Designer components are required to edit DTS packages.","Source Type: MSDB","Package Location: MOL240605-10","Instances: 1",
SQL Server 2000 Data Transformation Services,"PreUpgrade","SQL Server 2000 Meta Data Services packages are not supported.","Existing Meta Data Services packages should be moved to SQL Server storage (in the msdb database) or to structured storage files before you upgrade. SQL Server 2005 does not install support for SQL Server 2000 Meta Data Services
SQL Server 2000 Data Transformation Services,"PostMigration","Replace functionality of complex Data Transformation task encapsulated in Execute DTS 2000 Package task.","The SQL Server 2005 Integration Services (SSIS) Package Migration Wizard does not migrate complex Data Transformation tasks in SQL Server 2000 Data Transformation Services (DTS) packages. The migrated package will contain encapsulated DTS functionality that must eventually be removed or redesigned.","Package Name: BPATL","Source Type: MSDB","Package Location: BPATL","Instances: 17",
SQL Server 2000 Data Transformation Services,"Advisory","Upgrade Advisor reports only on the most recent version of each DTS package.","Upgrade Advisor reports only on the most recent version of each DTS package. To report on multiple versions of a DTS package, use the SSIS Package Migration Wizard, which is included with SQL Server 2005.","Source Type: MSDB","Package Location: MOL240605-10","Instances: 1",
SQL Server 2000 Data Transformation Services,"Advisory","SQL Server 2000 Data Transformation Services is deprecated.","You must completely migrate existing SQL Server 2000 Data Transformation Services (DTS) packages to SQL Server 2005 Integration Services packages before support is withdrawn.","Source Type: MSDB","Package Location: MOL240605-10","Instances: 1",

Open in new window

0
Comment
Question by:jeebee75
2 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 2000 total points
ID: 23723317
Table Name: DocumentIndex  - > Ignore the warning as you have no records in this table..

DTS package - > The warning indicates that the package hasn't been completely migrated to SSIS due to complex tasks.  Save the relevant DTS package as a structured storage file (*.dts) in SQL 2000 before proceeding with the upgrade and if the converted SSIS package has problems post upgrade, you can still run legacy DTS using sql_run.msi..
0
 

Author Closing Comment

by:jeebee75
ID: 31550628
Thanks!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question