Migrate data from local postgresql to cloud

0
Hello, I have an  app that I got the data locally, I was using database migration in local testing but realized you cannot import the local database to cloud. I tried links like https://community.mendix.com/link/space/databases/questions/138357. But when I load the backup file from postgre it does not work. Even if I tried changing nothing(just getting the backup from the cloud, putting it to postgre and restoring back), it does not work.  Those similar migrations all have tree files, but when I load full snapshot, there is only db and the metadata. I don't know if that is the reason. I have a big data so, it would take so much time to enter one by one. Is there anything additional that I need to do or did wrong? Or is there any other options? Thank you already for all the help. 
asked
1 answers
1

How to Move Data Between Local and Mendix Cloud

  • You cannot directly import a local database (.dump or .sql) into Mendix Cloud.

  • To move data from local to cloud:

    • Use the Excel Importer module to upload Excel files.

    • Alternatively, use REST APIs or microflows to push data from local to cloud.

  • To restore a Mendix Cloud backup locally:

    • Use the pg_restore command:

      pg_restore -U postgres -d your_local_db --clean --no-owner cloud-backup.dump

    • Ensure your local PostgreSQL version matches the cloud environment.

  • Mendix Cloud snapshots only include the database and metadata, not uploaded files or documents.

  • The most reliable method is to export your local data to Excel and import it into the cloud using the Excel Importer module.

answered