# Migrating to Discourse platform
**URL:** https://meta.discourse.org/t/migrating-to-discourse-platform/22021
**Category:** Self-hosting
**Created:** [November 10, 2014, 8:04pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021 "2014-11-10T20:04:48Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@sandeepberi81](https://meta.discourse.org/u/sandeepberi81)
#### Post date: [November 10, 2014, 8:04pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/1 "2014-11-10T20:04:48Z")
Hello everyone,
If we migrate to Discourse, how easy is it port historical forum content over to the new Discourse platform.
Also, in the future if we decide to move from Discourse and go back in-house, how easy is it to liberate/move the data out of Discourse back in-house?
Thanks for your help!
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [November 10, 2014, 11:55pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/2 "2014-11-10T23:55:51Z")
See `/admin/backups` on your install – you can export or import your data right from your web browser, any time you want.
---
### Author:  [@sandeepberi81](https://meta.discourse.org/u/sandeepberi81)
#### Post date: [November 11, 2014, 9:21pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/3 "2014-11-11T21:21:39Z")
Thanks for the response!
---
### Author:  [@sandeepberi81](https://meta.discourse.org/u/sandeepberi81)
#### Post date: [November 11, 2014, 9:29pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/4 "2014-11-11T21:29:41Z")
Also, I had a couple of additional questions with regards to getting Discourse set up:
- I realize Discourse has an in-built Analytics dashboard. If we want to add and report on additional custom metrics, how easy is it to add new code to query backend tables?
- How easy is it to create custom rules for users to build trust and develop custom badges?
- Finally, saw on the website that there are two different options for hosting the solution: on-premise and Discourse hosted? How do they differ in terms of features/support and how should one think about that?
Appreciate the help!
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [November 11, 2014, 9:34pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/5 "2014-11-11T21:34:01Z")
> [@sandeepberi81](#):
>
> I realize Discourse has an in-built Analytics dashboard. If we want to add and report on additional custom metrics, how easy is it to add new code to query backend tables?
That’s certainly on the wishlist.
> [@sandeepberi81](#):
>
> How easy is it to create custom rules for users to build trust and develop custom badges?
Very easy, as long as you have someone that can write SQL.
> [@sandeepberi81](#):
>
> Finally, saw on the website that there are two different options for hosting the solution: on-premise and Discourse hosted? How do they differ in terms of features/support and how should one think about that?
Any non-hosted install will be supported here at Meta as long as it uses the Docker system.
---
### Author:  [@sandeepberi81](https://meta.discourse.org/u/sandeepberi81)
#### Post date: [November 11, 2014, 9:41pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/6 "2014-11-11T21:41:16Z")
Thanks that sounds great.
Quick follow up: it seems like if we do a Discourse hosted installation, it’s currently not possible to write custom backend SQL queries to gather and report out on additional metrics. Is that correct?
Also, if we do on-premise, is it possible to query backend tables and create these custom metrics?
---
### Author:  [@sandeepberi81](https://meta.discourse.org/u/sandeepberi81)
#### Post date: [November 11, 2014, 10:30pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/7 "2014-11-11T22:30:42Z")
Was just thinking, if we can get the session logs, then is it possible to analyze that to develop and create custom metrics?
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [November 11, 2014, 10:37pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/8 "2014-11-11T22:37:18Z")
> [@sandeepberi81](#):
>
> Quick follow up: it seems like if we do a Discourse hosted installation, it’s currently not possible to write custom backend SQL queries to gather and report out on additional metrics. Is that correct?
Not automatically, unless you go through some awkward steps including running and downloading a backup automatically.
---
### Author:  [@sandeepberi81](https://meta.discourse.org/u/sandeepberi81)
#### Post date: [November 12, 2014, 7:51pm UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/9 "2014-11-12T19:51:20Z")
Thanks @riking
So, to summarize, it is possible to analyze session logs to develop custom metrics as long we continually run and download a backup regularly through some script?
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [November 13, 2014, 1:14am UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/10 "2014-11-13T01:14:41Z")
Well, I think that the “user visit” and “post timings” tables should have enough data for you to analyze to start out.
---
### Author:  [@sandeepberi81](https://meta.discourse.org/u/sandeepberi81)
#### Post date: [November 13, 2014, 5:44am UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/11 "2014-11-13T05:44:03Z")
Thanks @riking.
Would the schema for these tables be available for me to look somewhere online? Thanks again!
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [November 13, 2014, 7:21am UTC](https://meta.discourse.org/t/migrating-to-discourse-platform/22021/12 "2014-11-13T07:21:15Z")
> **[discourse/app/models at main · discourse/discourse](https://github.com/discourse/discourse/tree/main/app/models)**
>
> main/app/models
Bottom of every file.