Hi all. We are looking to migrate from SQL Server to PostgreSQL and as such exploring different migration strategies.
Our current process for database changes is quite simple for developers. We have the list of tables organised by schema in a .sqlproj and the generation of ALTER/CREATE, etc. Scripts are done automatically in CI/CD using a DACPAC
Would using flyway enterprise's schema model be the correct alternative? As in the workflow I tried the schema model was used to create migration scripts which are the source of truth.
Has anyone had a workflow deploying purely using the schema model? As the documentation mentions “some limitations.” and I'm curious as to hear people's experiences.
Thanks.
Hi all. We are looking to migrate from SQL Server to PostgreSQL and as such exploring different migration strategies.
Our current process for database changes is quite simple for developers. We have the list of tables organised by schema in a .sqlproj and the generation of ALTER/CREATE, etc. Scripts are done automatically in CI/CD using a DACPAC
Would using flyway enterprise's schema model be the correct alternative? As in the workflow I tried the schema model was used to create migration scripts which are the source of truth.
Has anyone had a workflow deploying purely using the schema model? As the documentation mentions “some limitations.” and I'm curious as to hear people's experiences.
Thanks.