# Liquibase updateSQL

**URL:** <https://forum.flowable.org/t/liquibase-updatesql/3699>\
**Category:** Flowable Engine\
**Created:** [April 8, 2019, 2:34pm UTC](https://forum.flowable.org/t/liquibase-updatesql/3699 "2019-04-08T14:34:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sukalpo](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/sukalpo/32/1143_2.png) [@sukalpo](https://forum.flowable.org/u/sukalpo)\
**Post date:** [April 8, 2019, 2:34pm UTC](https://forum.flowable.org/t/liquibase-updatesql/3699/1 "2019-04-08T14:34:32Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![filiphr](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/filiphr/32/315_2.png) [@filiphr](https://forum.flowable.org/u/filiphr)\
**Post date:** [April 15, 2019, 10:51pm UTC](https://forum.flowable.org/t/liquibase-updatesql/3699/2 "2019-04-15T22:51:07Z")

</div>

Hey @sukalpo,

Have you looked at the [flowable-sql](https://github.com/flowable/flowable-sql) repository? It has some scripts that you could run to have the SQL generated for you.

Cheers,  
Filip

---

<div class="post-metadata">

**Author:** ![sukalpo](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/sukalpo/32/1143_2.png) [@sukalpo](https://forum.flowable.org/u/sukalpo)\
**Post date:** [April 16, 2019, 11:55am UTC](https://forum.flowable.org/t/liquibase-updatesql/3699/3 "2019-04-16T11:55:42Z")

</div>

@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.