I have one database for a Payload instance, let's say the development environment, and another database for a different Payload framework instance in the production environment. How can I transfer all my data from the development environment to the production environment using payload framework?
#Data Transfer from one Env. to another in payload
plucky carbon
winter mulchBOT
fallow bough
Hi!
I think the best way to move all your data would be by exporting it straight from the database and then into your other environment. Have at look at
- pg_dump / pg_restore (https://www.postgresql.org/docs/current/backup-dump.html) for Postgres
- mongodump / mongorestore (https://www.mongodb.com/docs/database-tools/mongodump/) for MongoDB
plucky carbon
Dumping and restoring data might be risky since my production website is actively running on a production server. I need a more robust and reliable solution to ensure data integrity without downtime.
fallow bough
You can do it while it's running. It would be super fast compared to any other solution. But you could always write a script that connect to your database, extract the data and insert it into the other one
kind forge
Yeah really the best and most robust way to do this is with a proper migration using the dump and restore method that @fallow bough mentioned.
If your migrating from say mongo to Postgres you’ll need to write a pretty complex script, I’ve done that before. Otherwise I can attest to simply copying a dev db onto a production one, having done the dump and restore method with both mongo and Postgres successfully before.