How to verify successful database migration

sgruberg

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?

ara3n

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.

AlexWiley

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.