CODEWITHSUNDEEP
liquibase
dbf
dbf

Reputation: 6499

Liquibase: runOnChange + rollback

According to Liquibase docs stored procs/triggers etc should be stored separately in a single copy and added to changeset with runOnChange to update them for each change. But what is a recommended way to rollback to the previous change? The only idea that I have is to copy them to a separate folder for each release and add apply operation of this version as a rollback (for example, have sql\procs\current for last version all added to changelog as apply and sql\procs\1.0.0 is a copy of sql\procs\current when we started new 1.0.0 release). Are there any best practices for it? Thanks!

Upvotes: 1

Views: 1956

Answers (1)

Albert
Albert

Reputation: 601

We keep single copy of replaceable objects (procs/triggers/views etc) and use version control system (VCS) - git in our case.

When you want to rollback to previous version, just revert to relevant commit in VCS and run liquibase update.

Tutorial using Oracle - we are working by this tutorial for two years.

Upvotes: 3

Related Questions