I wanted to migrate one of our SQL 2000 database to new SQL 2008 server.
So to check migration compatibility I executed SQL 2008 upgrade adviser for SQL2000 database.
Upgrade adviser showed me very less issues. So I checked some SQL2000 db objects manually and I 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 about this upgrade adviser issue? is there any alternative tool available to check db compatibility?