Tuesday, January 22, 2013 6:54 AM
we are migrating one of our SQL 2000 database to new SQL 2008 R2 server.
So to check migration issues, I executed SQL 2008 upgrade adviser for SQL2000 database.
Upgrade adviser showed me very less issues. So I manuallu checked some SQL2000 db objects and found it is not reporting all issues. Like one of the SP is using non-ansi join (=*) but it is not reported by upgrade adviser.
anyone knows why this is not coming in upgrade adviser report? is there any alternative tool available like upgrade adviser?
Tuesday, January 22, 2013 11:47 AMModerator
You can try with SQL Server 2008 R2 Upgrade Advisor with SP1 from the following link:
Hope this helps.
Tuesday, January 22, 2013 4:48 PM
I have downloaded from same link. It didnt help :(
Tuesday, January 22, 2013 5:07 PMModerator
Please create a trace using SQL Server 2000 Profiler and provide that trace to Upgrade Advisor. Execute those stored procedures while the trace is created.
Hope this helps.
Wednesday, January 23, 2013 5:06 AMModerator
SQL Server 2000 with Service Pack 4 is supported to upgrade to SQL Server 2008 R2. Please apply SQL Server Service Pack 4 before you upgrade.
Please refer to Version and Edition Upgrades: http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx.
TechNet Community Support
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Wednesday, January 30, 2013 8:19 AM
Wednesday, January 23, 2013 11:54 AMCan you please have an go through the checklist and White paper of Overview: Upgrading from SQL Server 2000 to SQL Server 2008(type in google engine).
Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.