Liquibase updateSQL

**sukalpo** · April 8, 2019, 2:34pm

Hi All,

Our project uses liquibase, but for deployment to UAT we dont directly run liquibase to DB. We actually run liquibase updateSQL and then run the scripts generated. How do I get the flowable db scripts as part of liquibase updateSQL?

**filiphr** · April 15, 2019, 10:51pm

Hey @sukalpo,

Have you looked at the flowable-sql repository? It has some scripts that you could run to have the SQL generated for you.

Cheers,
Filip

**sukalpo** · April 16, 2019, 11:55am

@filiphr Thanks for the reply. I havent looked at the repository but I looked at the application boot up logs and found the sql that was executed. I am getting the sql from there

2019-04-16 19:53:24 [restartedMain] INFO  o.f.i.e.impl.db.IdmDbSchemaManager - performing create on identity with resource org/flowable/idm/db/create/flowable.h2.create.identity.sql

2019-04-16 19:53:24 [restartedMain] INFO o.f.idm.engine.impl.IdmEngineImpl - IdmEngine default created
2019-04-16 19:53:24 [restartedMain] INFO o.f.c.e.i.db.CommonDbSchemaManager - performing create on common with resource org/flowable/common/db/create/flowable.h2.create.common.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.i.s.i.d.IdentityLinkDbSchemaManager - performing create on identitylink with resource org/flowable/identitylink/service/db/create/flowable.h2.create.identitylink.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.i.s.i.d.IdentityLinkDbSchemaManager - performing create on identitylink.history with resource org/flowable/identitylink/service/db/create/flowable.h2.create.identitylink.history.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.e.s.i.d.EntityLinkDbSchemaManager - performing create on entitylink with resource org/flowable/entitylink/service/db/create/flowable.h2.create.entitylink.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.e.s.i.d.EntityLinkDbSchemaManager - performing create on entitylink.history with resource org/flowable/entitylink/service/db/create/flowable.h2.create.entitylink.history.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.t.s.impl.db.TaskDbSchemaManager - performing create on task with resource org/flowable/task/service/db/create/flowable.h2.create.task.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.t.s.impl.db.TaskDbSchemaManager - performing create on task.history with resource org/flowable/task/service/db/create/flowable.h2.create.task.history.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.v.s.i.db.VariableDbSchemaManager - performing create on variable with resource org/flowable/variable/service/db/create/flowable.h2.create.variable.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.v.s.i.db.VariableDbSchemaManager - performing create on variable.history with resource org/flowable/variable/service/db/create/flowable.h2.create.variable.history.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.j.s.impl.db.JobDbSchemaManager - performing create on job with resource org/flowable/job/service/db/create/flowable.h2.create.job.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.e.impl.db.ProcessDbSchemaManager - performing create on engine with resource org/flowable/db/create/flowable.h2.create.engine.sql
2019-04-16 19:53:24 [restartedMain] INFO o.f.e.impl.db.ProcessDbSchemaManager - performing create on history with resource org/flowable/db/create/flowable.h2.create.history.sql

I was more eager to see if there is any property that spits out these sql when we have liquibase configured and we set the goal of liquibase as updateSQL.