We're beginning our migration from SQL 2000 to SQL 2008. The upgrade
advisor is giving us a couple of messages that I don't know how to resolve.

- "Upgrading will cause Full-Text Search to use instance-level, not global,
word breakers and filters by default". We don't even use Full-Text search;
is there a way to uninstall it in SQL 2000 so I don't get this message in
the upgrade advisor? I tried disabling the service but that didn't help. I
searched the web and found someone with a similar situation but he was never
given any solution.

- "SQL Server 2000 Meta Data Services packages are not supported". I don't
have any Meta Data packages. I followed the corrective actions but don't
see any meta data packages to edit and save in msdb.

- "SQL Server 2000 DTS Designer components are required to edit DTS
packages". This server has zero DTS packages. So why do I need/want to
install the designer components?

- Speaking of DTS, can we still run DTS packages in legacy mode in SQL 2008,
like we can in SQL 2005? We do have DTS packages on another server we'll be
upgrading in the near future.

As this is our first server we're migrating, we obviously want to get it
right the first time, so I appreciate any input you can provide.

Thanks, Andre

Andre (no (AT) spam (DOT) com) writes:
If you don't use full-text, why bother about the message?

Good, you're all set then.

If you don't use DTS, I guess you don't need to.

I thikn you can, but I've never used DTS (or SSIS), so I don't know for
sure.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thanks for the reply Erland.





Thanks, Andre

Andre (no (AT) spam (DOT) com) writes:
I've never run the wizard, but if you feel compelled to click on
"Resolved" do so. But, I mean, it's not that the police will come and
get you if you don't.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

lol - ok, got it. I just wondered if it will affect the conversion/upgrade
of SQL if I didn't click it. Thanks again.

Andre