Moving the data from staging to production [Jun 29]

Discord-Discussions
1

:man_raising_hand: zblesk asked

What is a good way of moving data between NocoDB instances without losing data or metadata?

I have some data in my staging environment - both from existing tables (created without NocoDB) and from Airtable. I have cleaned them up in the DB.

Now I would like to move them to the production NocoDB instance, but I dunno how best to do that.

Seems if I just export/import them on the DB level, I will lose all the metadata like column types.

Tried going via csv export/import, but that doesn’t seem better, and it seems to be impossible to retain references between tables.

How to do this?

2

:person_tipping_hand: o1lab replied

if all your tables were on NC_DB - it will be a simple pg_dump.. you could give that a try

3

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs