DB Migration to On-Prem

Team,
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.
Thanks

Hi,

You can use the bench backup and restore to achieve the same.

Check this documentation for complete information: bench backup
and bench restore

Thanks,

Divyesh Mangroliya

Thanks will take a look at the docs.

Have you had success generating Logical/Physical DB structure using a tool such as Toad?