Skip to Content
Sep 22, 2022 at 02:13 PM

How to create a PostgreSQL database task migration with Cloud Foundry and Node.js

350 Views Last edit Sep 27, 2022 at 10:22 AM 2 rev

I'm working on a Node.js project on Cloud Foundry and BTP using PostgreSQL as the database, now when I need to change a table structure I made changes in the data-model.cds and redeploy the project in the BTP space, what I want to develop is a database migration manager that can handle and run migrations and make changes automatically without removing the PostgreSQL instance and redeploying my project.

I didn't find a technical way to start doing that and there is no documentation that can help with PostgreSQL database. Can anyone help ?