How to verify successful database migration

sgruberg
sgruberg Member Posts: 4
edited 2009-12-29 in NAV/Navision Classic Client
Our company is migrating our NAV using SQL db from one hosting company to another.  After we have successfully backed up and restored our data (NAV custom code, and NAV itself) how can we check (verify) if everything migrated correctly?  For example, how can we verify if all the data came through, and the custom code we created in NAV all migrated correctly? 

Are their built in tools in NAV and/or manual checklists that are best practices?

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Make sure you have same number of records in all the tables
    File->database->information->tables.


    On that same window you can select all tables and click on Test

    and save it to file.


    Run some test transaction. Run you reports.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • AlexWiley
    AlexWiley Member Posts: 230
    You should run these reports, at the very least, before migrating and then again afterwards to make sure they match:

    -Trial Balance
    -Customer Aging
    -Vendor Aging

    Then pick a couple inventory reports, like Inventory to GL Reconcile. Additional reports for other functional areas, like fixed assets, warehousing, manufacturing, HR, etc. The main reports each department head uses, basically.

Categories