If we are currently working with Liquibase to database automation how to handle manual changes?
Currently I’m doing schema changes with creating changelog file and applying it. But what if some other do changes directly to the database without using changelog file at the same time when someone doing changes? Do liquibase track those actions?
Ideally, once you begin using Liquibase no one would make changes to your schema outside of Liquibase. But if they do I recommend the following:
Code the same change into a Liquibase changelog
Execute one of these Liquibase commands to record the new changeset into the databasechangelog table (makes it look like Liquibase did execute the changeset):
One thing you can do in that situation is to use the diffChangeLog command to capture the manual change into your changelog file, and then use the changelog sync command as mentioned below to show that the change in the changelog file has been applied to that database instance.