Can Liquibase generate functions, packages, package body in separate folders when using generate-changelog?

Applies to

• Liquibase Pro
• Liquibase Open Source (Community)

Conditions

• Any version of Liquibase Pro or Open Source

Question

Can Liquibase generate functions, packages, and packagebody in separate folders when using generate-changelog?

Answer

Yes, Liquibase Pro does this automatically.

While Liquibase Open Source stores all changesets in a changelog, Liquibase Pro creates a directory called Objects and places the directory at the same level as your changelog.

The Objects directory contains subdirectories for each of the stored logic types:

• package
• packagebody
• function
• stored procedure
• trigger

The generate-changelog command will not create the Objects directory if:

• You don't have a valid Liquibase Pro license key.
• Stored logic is not present in the database.
• The target database does not support the generate-changelog command and stored logic objects.
  • You can check if your database supports this command by reviewing your database on the Support Databases page.
• The changelog file is written in formatted SQL. The Objects folder can only be created when generating XML, JSON, or YAML changelogs.
• There is a pre-existing directory called Objects that was created outside Liquibase.

Related Article(s)

generate-changelog Documentation