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?
Hello @nikeshi ,
Could you please elaborate your use case or the doubt you have. This will help community user to understand the problem and provide better solution.
For a example:
I added a column to the table directly in the database. Is there way to track that I did schema change?
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.