How to transfer some data from DEV/QA to prod environment?

Get Help
1

Hello, guys, I’m freaking out here, actually, I have 2 Metabase instances DEV/QA and PROD. all instances are running in docker with postgres DB. I’m trying to migrate only some dashboards and questions from DEV/QA to PROD but, it’s seen as I can only migrate all postgres database, it is impracticable.

The questions is it, is there any way to migrate my data from DEV/QA without making a full database restore to PROD? i just want to migrate one dashboard or two.

Thanks.

2

Hi @psantos

You would have to do it manually. There’s currently (0.32.8) no export/import feature for settings/dashboards/questions.

The current work-arounds:

  1. Totally manually, simply just going through everything one-by-one in two browser windows.
  2. Using the API (this is a good solution, if you’re doing similar process many times, but will take some time to code)
  3. Fiddling with the database and trying to copy things from DEV to PROD (this will most likely kill your database).

There’s an open issue about this - go and upvote by clicking :+1: on the first post:
https://github.com/metabase/metabase/issues/6485

3

hello @flamber any progress on this? if not can you describe how to use the API?

4

@jean A lot has changed, there's now Serialization: https://www.metabase.com/docs/latest/installation-and-operation/serialization

If you want to use the API https://www.metabase.com/docs/latest/api-documentation, the best way to learn the API, is to just use Metabase while having your browser developer Network-tab open and looking at the request, and what data is being send/received.

5

is there a serialization alternative for free users?

6

@jean Using the API. Otherwise try searching the forum, but more recent topics.

1 Like
7

thanks. let me keep checking