Sql 2000 DB migration to SQL 2008

  • 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?

  • Ignore, mis read at the end of the day.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • anyone knows about this issue? 🙁

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply