Hi!
I want to make sqlcl use databasechangelog table from a specific schema.
Assume we have the following set of schemas:
MGMT - Management schema
ORDERS - Biz schema
SHIPPINGS - Biz schema
And I have the following main.sql file to deploy my code:
alter session set current_schema=ORDERS
lb update -changelog orders/controller.xml
alter session set current_schema=SHIPPINGS
lb update -changelog shippings/controller.xml
But with such an approach sqlcl creates databasechangelog table in the current schema. I want to manually tell sqlcl to use one from MGMT . Using liquibase I can set liquibaseSchemaName property (https://docs.liquibase.com/workflows/liquibase-community/creating-config-properties.html) to define such a schema.
Is sqlcl able to handle the same behavior? If yes, then how to achieve it?
Any thoughts would be appreciated.