Liquibase逆向工程咨询：能否基于MySQL生成Liquibase脚本

Absolutely you can! Generating Liquibase changelogs from an existing MySQL database is fully supported, and there are a couple of straightforward ways to pull this off—whether you prefer using Liquibase's command-line tool or integrating it directly into your Spring Boot project.

This is a quick, standalone approach that doesn't require tying into your project build setup:

• First, make sure you have Liquibase installed, and grab the MySQL JDBC driver (you can download the mysql-connector-java JAR from Maven Central).
• Create a liquibase.properties file with your database connection details:

driver: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/your_database_name?useSSL=false&serverTimezone=UTC
username: your_db_username
password: your_db_password
changeLogFile: db/changelog/generated_changelog.xml
classpath: path/to/mysql-connector-java-x.x.x.jar

• Run the generate command in your terminal:

liquibase generateChangeLog

• This will create an XML changelog at the path you specified, containing all your tables, columns, indexes, and constraints. If you prefer YAML or JSON instead, add the --format=yaml or --format=json flag to the command.

If you want to generate the changelog directly within your project build, use Maven or Gradle plugins:

Maven Setup #

Add the Liquibase Maven plugin to your pom.xml and configure your database connection:

<plugin>
    <groupId>org.liquibase</groupId>
    <artifactId>liquibase-maven-plugin</artifactId>
    <version>your-liquibase-version</version>
    <configuration>
        <driver>com.mysql.cj.jdbc.Driver</driver>
        <url>jdbc:mysql://localhost:3306/your_database_name?useSSL=false&serverTimezone=UTC</url>
        <username>your_db_username</username>
        <password>your_db_password</password>
        <changeLogFile>src/main/resources/db/changelog/generated_changelog.xml</changeLogFile>
    </configuration>
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>your-mysql-driver-version</version>
        </dependency>
    </dependencies>
</plugin>

Run the Maven command to generate the changelog:

mvn liquibase:generateChangeLog

Gradle Setup #

Add the Liquibase plugin to your build.gradle and configure the database details:

plugins {
    id 'org.liquibase.gradle' version 'your-liquibase-plugin-version'
}

liquibase {
    activities {
        main {
            driver 'com.mysql.cj.jdbc.Driver'
            url 'jdbc:mysql://localhost:3306/your_database_name?useSSL=false&serverTimezone=UTC'
            username 'your_db_username'
            password 'your_db_password'
            changeLogFile 'src/main/resources/db/changelog/generated_changelog.xml'
        }
    }
    dependencies {
        liquibaseRuntime 'mysql:mysql-connector-java:your-mysql-driver-version'
        liquibaseRuntime 'org.liquibase:liquibase-core:your-liquibase-version'
    }
}

Run the Gradle task to generate the changelog:

./gradlew generateChangeLog

• The generated changelog might include minor details (like default values or column comments) that you don't need in your project—take a minute to review and clean it up to match your team's standards.
• If your database has stored procedures, triggers, or views, Liquibase can generate changelogs for those too. Use the --includeObjects flag to specify which object types to include (e.g., --includeObjects=procedure,trigger).
• Double-check that your Liquibase version is compatible with your MySQL driver version to avoid connection or parsing errors.

内容的提问来源于stack exchange，提问作者Aiyush Saini