Home Forums Microsoft Access Microsoft Access ref integrity after Migrating database to sql server 2008 R2 RE: ref integrity after Migrating database to sql server 2008 R2

  • I downloaded and ran the Migration assistant. It did a nice job moving the tables. Afterwards, I logged into SQl Server Mgmt Studio and activated the database diagram. Some of the Ref Integrity successfully migrated and by adding the missing tables and establishing the RI links, I completed that part of the process.

    However, the access queries did not fare so well. Over 60 errors were generated.

    Still in retrospect, the migration assistant is much better than the upsizing tool.

    When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

    Once you've accepted your flaws, no one can use them against you.