Migrating user's logins and setting (or analytic graphs) from one Metabase to another

Get Help
1

We have 2 instances of running Metabase:

  • One is ahead with many more graphs and other analytic works. But it has only a few users.
  • Another with many users (this is the production version). But are missing a lots of analytics graphs compared to the other.

How can I migrate those newest analytic works from the "dev" version to production? I tried replacing metabase-data.mv.db from "dev" into production but that does not have many of the invited users. If I do that, we lose the created users.

Or, is it possible to migrate user's information?

2

Hi @daniel123
You should absolutely not be using H2 in production: https://www.metabase.com/docs/latest/installation-and-operation/migrating-from-h2

The easiest would be to create all the users on the Dev instance. You can use the API to create the users: https://www.metabase.com/docs/latest/api/user#post-apiuser

Everything in the application database is by IDs, so there's no easy way to merge the data.
There's Serialization, which allows you to copy data between instances: https://www.metabase.com/docs/latest/installation-and-operation/serialization