Command-line: baseline

Baselines an existing database, excluding all migrations up to and including baselineVersion.

Usage

migratedb [options] baseline

Options

See configuration for a full list of supported configuration parameters.

Sample configuration

migratedb.driver=org.hsqldb.jdbcDriver
migratedb.url=jdbc:hsqldb:file:/db/migratedb_sample
migratedb.user=SA
migratedb.password=mySecretPwd
migratedb.connectRetries=10
migratedb.initSql=SET ROLE 'myuser'
migratedb.schemas=schema1,schema2,schema3
migratedb.table=schema_history
migratedb.tablespace=my_tablespace
migratedb.callbacks=com.mycomp.project.CustomCallback,com.mycomp.project.AnotherCallback
migratedb.skipDefaultCallbacks=false
migratedb.baselineVersion=1.0
migratedb.baselineDescription=Base Migration
migratedb.workingDirectory=C:/myProject
migratedb.createSchemas=true
migratedb.jdbcProperties.myProperty=value

Sample output

> migratedb baseline

MigrateDB 1.0.0 

Creating schema history table: "PUBLIC"."migratedb_state"
Schema baselined with version: 1

Sample JSON output

> migratedb baseline -outputType=json

{
  "successfullyBaselined": true,
  "baselineVersion": "1",
  "migratedbReleaseVersion": "1.0.0",
  "database": "testdb",
  "warnings": [],
  "operation": "baseline"
}

Command-line: repair ➡️