Forum Stats

  • 3,770,075 Users
  • 2,253,061 Discussions
  • 7,875,300 Comments

Discussions

Forward patching with SqlCL Liquibase changelogs linking to actual ddl-files

Paavo
Paavo Member Posts: 675 Silver Badge

While waiting SqlCL to be have more recent Liquibase supporting linking sql / ddl-files in the changelog-files came to conclusion that it would be very elegant to have Datamodeler to do the disciplined merge ddl's.

So shortly:

1.) make change to design

2.) "synchronize data dictionary with model"

3.) DDL Preview with option to file per object (matching the genobject).

4.) Save to sqlcl liquibase Release-target directory with disciplined runorder

5.) Edit the changesets per object in changelogs to include new patch-files (4.)

6.) Add all files to version control, commit and push

7.) Launch sqlcl to patch

So the target directory has e.g. something like this:

changelogs
I...emp.xml
I...dept.xml
scripts
I...Release202111
    I..00_emp-patch-ddl-from-DModeler.sql
    I..01_dept-patch-ddl-from-DModeler.sql
I...Release202112
I...Release202201
Paavo
1 votes

Active · Last Updated