Revision history [back]

Yes, it is possible to separate the storage of metadata and the execution of changelog in Liquibase. This can be done by configuring Liquibase to use different databases for storing metadata and executing changelogs.

For example, the metadata can be stored in a MySQL database and the changelogs can be executed in a PostgreSQL database. This can be achieved by specifying different database URIs, usernames, and passwords for metadata and changelog in Liquibase configuration.

Another approach is to store the metadata in the file system and execute changelogs from the database. This can be done using Liquibase's file-based change log feature. In this approach, the metadata is stored in XML or YAML files, and Liquibase executes the changelogs from the database.

Overall, the separation of metadata storage and changelog execution in Liquibase provides flexibility and can help in managing the database schema changes effectively.