Run Upgrade Advisor post-upgrade | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Run Upgrade Advisor post-upgrade

Greetings, I have a client whose DBA upgraded their SQL 2000 database to SQL 2005. They still have it running in 8.0 compatibility mode, for various reasons, and would like me to help them develop a migration strategy to get them to full 9.0 compatibility. My question is: can I run the Upgrade Advisor on a SQL 2005 engine database running in 8.0 compatibility mode and get anything useful? I already know there will be some issues with existing DTS packages but it would be nice to catch any other issues in advance. I know that the Upgrade Advisor was run before the upgrade took place but to my knowledge the report was not saved and none of the recommendations were followed. Any help would be greatly appreciated. Cheers, Lon
Can you check the logs created by Upgrade Advisor and refer tohttp://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx in this regard. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Satya, Thanks for the reply but the upgrade was done back in July and to my knowledge the report logs were not saved. The DBA who performed the upgrade, and ran the Advisor, is no longer with the company. Hence my question. Lon
If the databases are already in SQL 2005 with a previous upgrade and only waiting for database compatbility, then you can turn on the switch to 90. Suggest that test the pattern before applying it on production srever. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Read the the following article…and check your code code by syscomments table to see if you using any discotinued code your procedures/veiws/trigger… you convert dts packages to SSIS packages… All dts packages will not migrate strait forward…Most of the packages you may need create them in SSIS… mean time you can DTS add-ins to run… Discontinued Database Engine Functionality in SQL Server 2005
http://msdn2.microsoft.com/en-us/library/ms144262.aspx First test ….test… test in dev… then change cmpt level to 90 in production…
Mohammed U.
]]>