Version control for database

General information about db version control and liquibase

Why we need database version controlling

Liquibase: Git for the Database

Fill liquibase changeLog file from existing databse 

1.1 Generate a changeLog from an existing Database (Reverse engineering) with a Maven Plugin

  mvn liquibase:generateChangeLog 

1.2 Generate a changeLog from an existing Database with data

  mvn liquibase:generateChangeLog -Dliquibase.diffTypes="data" 

2. Synchronize metadata. Create tables that liquibase uses for handling the versions

  mvn liquibase:changeLogSync 

3. Run command update to apply the change set

  mvn liquibase:update 

More explanations: 1 and 2

Triggers with liquibase

Example of trigger in changeLog file

Create trigger in changeLog file (official doc)

Simple demo with spring-boot

Good example (baeldung)

My own demo