Secure way to swap dev and live data

Hello fellow bubblers.

I’m in the process of deploying a new app version, a major upgrade where need to publish some (or all) data between Dev and Live. All the data in the DEV database should be copied to Live, but the Live data must be preserved as a backup.

The options I see:

  • To make a backup of the Live tables into CSV files, copy dev to Live and the restore CSV files. Safer (the data is stored outsitde bubble) but very complex work,
  • Marking date and time and doing a complex copy/restore process: Copy dev to live, restore live in time, copy to dev, restore live to the dev-copy-point.

  • Ask for bubble to help me.

I fear that data can be lost in the process,