• Upgrade advisor doesn't import databases. It just checks for possible problems that the DB will have on the new version (using removed features, etc).

    Backup/restore is how we normally get databases onto a new version in production (or sometimes detach/attach, but that's riskier). Moving the data manually would take way too much time and allows for so much to go wrong due to user error.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass