Bonjour,

Je viens de reprendre la gestion de nos serveurs SQL, mais malheureusement mes connaissances sont encore trop limitées.

Je dois upgrader un SQL 2000 en 2005. La version actuelle est : 8.00.760, soit SP3. Pour ugrader, je pars depuis le 2005 SP2.

Comme travaux préparatoires, j'ai lancé l'Upgrade Advisor, mais les reports fournis ne m'aident pas beaucoup pour les erreurs suivantes :

Before : SQL Server 2000 Meta Data Services packages are not supported
Before : SQL Server 2000 DTS Designer components are required to edit DTS package
After : No DTS packages were found on the server that you selected to analyze
Advisory : SQL Server 2000 Data Transformation Services is deprecated
Advisory : Upgrade Advisor reports only the most version of each DTS package


Avec le détail ci-dessous :

"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; therefore the Package Migration Wizard will be unable to access Meta Data Services packages after upgrade in the absence of the SQL Server 2000 Client Tools.","Source Type: MSDB","Package Location: CHRPNT10","Instances: 1",
"SQL Server 2000 Data Transformation Services","PreUpgrade","SQL Server 2000 DTS Designer components are required to edit DTS packages","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.","Source Type: MSDB","Package Location: CHRPNT10","Instances: 1",
"SQL Server 2000 Data Transformation Services","PreMigration","No DTS packages were found on the server that you selected to analyze","No DTS packages were found on the server that you selected to analyze.","Source Type: MSDB","Package Location: CHRPNT10","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: CHRPNT10","Instances: 1",
"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: CHRPNT10","Instances: 1",


Est-ce que la différence est trop élevée entre 2000 SP3 et 2005 SP2, dois-je d'abord passer le SP4 de la version 2000 ?