We have decommissioned our ERPNext and in the process of migrating the DB to an on-prem server. Any advice on the process (i.e. DUMP Structure, DUMP Data, CSV Tables, Connect Tables) to retain integrity for building scripts to access AR/AP historical info.
You can use the bench backup and restore to achieve the same.
Thanks will take a look at the docs.
Have you had success generating Logical/Physical DB structure using a tool such as Toad?