Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

PaavoNov 8 2021

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
Comments
Post Details
Added on Nov 8 2021
8 comments
312 views