Geek Answers Handbook

A couple of questions from Liquibase noob

Im evaluating liquibase to launch a project today.

Has anyone used it to create procedures, functions, basically all plsql materials?

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

Thanks in advance.

+5
source share
3 answers

There is a built-in createProcedure in Liquibase for managing procedures. The best approach is usually to combine tags or tags with runOnChange so that Liquibase updates your procedure only when you update the definition. That way, you can make the difference between your xml files for change files over time and see how the procedure has changed.

Using the sqlFile tag for a reference file for stored-proc is also popular or, as you said, you can use sql for inline custom sql.

+5
source

sql , , JDBC MySQL, Liquibase. , , sqlFile, , SP// , , . SP/ , .

runOnChange = "true" changeSet, sqlFile, . (, ) .

+2

Liquibase , Liquibase .

sql, xml .

+1

More articles: