DeployHubProject / DeployHub-Pro

DeployHub Pro Pipeline Status Project
https://www.openmakesoftware.com/application-release-automation-for-continuous-delivery/
Other
11 stars 4 forks source link

migrate data from OSS postgreSQL to the PRO #239

Closed piyush94 closed 5 years ago

piyush94 commented 5 years ago

Is there a way to migrate data from postgresql?

sbtaylor15 commented 5 years ago

We need to do an export using Windows pgAdmin tool. In the pgAdmin, navigate to the postgres database and dm schema. Right click and select backup. Use Plain for the format. On the Dump options, select pre-data, post-data and data. Also, select "Use Insert Commands". Send me the exported file as a zip. I want to load it into my db first to check that everything get migrated correctly. Pro has more tables and new columns that I want to verify that they get added in conjunction with your data.

piyush94 commented 5 years ago

Backup file: DH_OSS_Backup.zip

sbtaylor15 commented 5 years ago

Can you send me a zip of the data directory that is being mounted on the docker run command? I can verify that the migration of the tables works using the low level database files.

sbtaylor15 commented 5 years ago

The docker containers will migrate the persistent storage from OSS schema to the Pro schema. But you cannot go from the Pro to OSS.