Baselines an existing database, excluding all migrations up to and including
> flyway [options] baseline
|url||YES||The jdbc url to use to connect to the database|
|driver||NO||Auto-detected based on url||The fully qualified classname of the jdbc driver to use to connect to the database|
|user||NO||The user to use to connect to the database|
|password||NO||The password to use to connect to the database|
|connectRetries||NO||0||The maximum number of retries when attempting to connect to the database. After each failed attempt, Flyway will wait 1 second before attempting to connect again, up to the maximum number of times specified by connectRetries.|
|initSql||NO||none||The SQL statements to run to initialize a new database connection immediately after opening it.|
|schemas||NO||The default schema for the database connection||Comma-separated list of schemas managed by Flyway. These schema names are case-sensitive.
|table||NO||flyway_schema_history||The name of Flyway's schema history table.
By default (single-schema mode) the schema history table is placed in the default schema for the connection provided by the datasource.
When the flyway.schemas property is set (multi-schema mode), the schema history table is placed in the first schema of the list.
|jarDirs||NO||Comma-separated list of directories containing JDBC drivers and Java-based migrations|
|callbacks||NO||Comma-separated list of fully qualified class names of Callback implementations to use to hook into the Flyway lifecycle.|
|skipDefaultCallbacks||NO||false||Whether default built-in callbacks (sql) should be skipped. If true, only custom callbacks are used.|
|baselineVersion||NO||1||The version to tag an existing schema with when executing baseline|
||The description to tag an existing schema with when executing baseline|
|licenseKey Flyway Pro||NO||none||Your Flyway license key (FL01...). Not yet a Flyway Pro or Enterprise Edition customer? Request your Flyway trial license key to try out Flyway Pro and Enterprise Edition features free for 30 days.|
flyway.driver=org.hsqldb.jdbcDriver flyway.url=jdbc:hsqldb:file:/db/flyway_sample flyway.user=SA flyway.password=mySecretPwd flyway.connectRetries=10 flyway.initSql=SET ROLE 'myuser' flyway.schemas=schema1,schema2,schema3 flyway.table=schema_history flyway.callbacks=com.mycomp.project.CustomCallback,com.mycomp.project.AnotherCallback flyway.skipDefaultCallbacks=false flyway.baselineVersion=1.0 flyway.baselineDescription=Base Migration
> flyway baseline Flyway 5.2.4 by Boxfuse Creating schema history table: "PUBLIC"."flyway_schema_history" Schema baselined with version: 1