为外部报告目的的数据迁移

I’m just looking for any best practices or processes to automatically migrate the entire database and schema from discourse to another database for reporting purposes. I’m thinking of just using the data explorer to expose each table as an API but I’m wondering if anyone else has any suggestions for what could be done that could be simpler.