Dear Experts,
I am planning to use Liquibase open source deployment in our org as part of DB changes.
I have below requirements or queries from my end. Can someone help me on this please.
We have a Prodcution database and database deployments will get applied on release specific like Release_1.1,Release_1.2
In Relase_1.1 we have bunch of SQL files like below from different developpers and which specific to only one DB
Release_1.1 (dir)
file1_tab1.sql (Author:ID will be user1:file1_tab1)
file2_tab1.sql (Author:ID will be user1:file2_tab1)
file1_tab2.sql (Author:ID will be user2:file1_tab2)
file2_tab2.sql (Author:ID will be user2:file2_tab2)
file3.sql (Author:ID will be user3:file3)
file4_tab1.sql (Author:ID will be user1:file4_tab1)
file4_tab2.sql (Author:ID will be user1:file4_tab2)
file5.sql (Author:ID will be user3:file5)
file7.sql (Author:ID will be user3:file7)
file8.sql (Author:ID will be user3:file8)
file9.sql (Author:ID will be user3:file9)
How can I update Liquibase changelog to execute includeALL to specific directory(Release_1.1) with below 3 conditional ways
Step1. sequence order required for the below files
file1_tab1.sql
file2_tab1.sql
file4_tab1.sql
file4_tab2.sql
Ex: file1_tab1.sql ==> file2_tab1.sql ==> file4_tab1.sql ==> file4_tab2.sql (In this order it should execute)
Step2. We want to skip some files in the same directory as below
file7.sql
file8.sql
Step3. The other remaining files will be execute in any order is fine
file1_tab2.sql
file2_tab2.sql
file3.sql
file5.sql
file9.sql
Also if I want to execute the Step2 later after my applocation deployments
Assume like Step1,3 is in Prd-deployment and Step2 is in post deployment order.
Please do the needful