Springboot supports two kinds of database migration tools, one is flyway and the other is liquibase. It also supports SQL script, which executes the specified script after initializing the data source.
Flyway.baseline-description
A description of the baseline version when the migration was performed.
Flyway.baseline-on-migrate
If the target schema is not empty when migrating, and if there are tables with no metadata, the baseline migration is performed automatically, false by default.
Flyway.baseline-version
Label the version of the existing schema when you begin the baseline migration, with a default value of 1.
Flyway.check-location
Verify that the location of the migration script exists, false by default.
Flyway.clean-on-validation-error
If clean is called automatically when a checksum error is found, the default is False.
Flyway.enabled
If Flywary is turned on, the default is true.
Flyway.encoding
Set the encoding for migration, default UTF-8.
Flyway.ignore-failed-future-migration
Default False if error migration is ignored when reading the metadata table.
Flyway.init-sqls
The SQL to execute when the connection is initialized.
Flyway.locations
The location of the migration script, default db/migration.
Flyway.out-of-order
Whether to allow unordered migrations, false by default.
Flyway.password
The password for the target database.
Flyway.placeholder-prefix
Sets the prefix for each placeholder, which is the default ${.
Flyway.placeholder-replacement
Placeholders whether to be replaced, by default true.
Flyway.placeholder-suffix
Set the suffix for each placeholder, default}.
Flyway.placeholders. [Placeholder name]
Set the value of placeholder
Flyway.schemas
Set the schema to be flywary migrated, case sensitive, default to connect default schema.
Flyway.sql-migration-prefix
The prefix of the migrated file, which is v by default.
Flyway.sql-migration-separator
The file name delimiter for the migration script, default __
Flyway.sql-migration-suffix
The suffix of the migration script, which defaults to. sql
Flyway.table
The metadata table name used by the Flyway, which defaults to Schema_version
Flyway.target
Target version used when migrating, default to latest versions
Flyway.url
The JDBC URL to use when migrating, and if not specified, uses the configured primary data source
Flyway.user
User name for migrating database
Flyway.validate-on-migrate
The default is true if the check is checked during migration.