I would like to get insight from the community on what others are doing (perhaps best practices) on where the databasechangelog is best located.
Right now, what we can do is create it on the current users schema (place all the changelog to a single schema) or override it with the target schema (each schema will have its corresponding databasechangelog).
I am leaning towards creating the databasechangelog under its corresponding schema . I think it is more manageable for a multi-schema database as well as future proofing in cases where the schema may need to be moved to a different database.
What do you think? What does other teams do using Liquibase in multi-schema environment?