# Data migration for external reporting purposes

**URL:** https://meta.discourse.org/t/data-migration-for-external-reporting-purposes/284737
**Category:** Data & reporting
**Created:** [November 7, 2023, 6:42pm UTC](https://meta.discourse.org/t/data-migration-for-external-reporting-purposes/284737 "2023-11-07T18:42:22Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![philip-ellis-sp](https://avatars.discourse-cdn.com/v4/letter/p/258eb7/32.png) [@philip-ellis-sp](https://meta.discourse.org/u/philip-ellis-sp)
#### Post date: [November 7, 2023, 6:42pm UTC](https://meta.discourse.org/t/data-migration-for-external-reporting-purposes/284737/1 "2023-11-07T18:42:22Z")

</div>

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](https://meta.discourse.org/t/32566?silent=true) 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.