Search code examples
sqlplsqlliquibase

Using Liquibase to create procedures

I'm evaluating liquibase for a project starting today.

Has anybody used it to create procedures, functions, basically all of the plsql stuff?

If not, is it possible to write embedded sql code in the xml files?

Solution

  • There is a built-in createProcedure tag in liquibase for managing procedures. The best approach is usually to combine the or tags with runOnChange so liquibase will update your procedure when and only when you update the definition. That way you can do diffs between your changelog xml files over time and see how the procedure has changed.

    Using the sqlFile tag to reference file per stored-proc is also popular, or, like you said, you can use the sql tag to inline custom sql.