db-config

db-config utility used to migrate sql schema, data.

db-config.properties

This file contains configured properties:

• config-properties-file: properties file contains jdbc connection, username, password
• db-migration-dir: where contains SQL scripts

For example: If you want to migrate sql scripts to H2 database, you will config

config-properties-file=../conf/application.properties
db-migration-dir=../conf/db/

In file ../conf/application.properties

sonar.jdbc=jdbc:h2:file:./target/foobar
sonar.user=sa
sonar.password=

In ../conf/db/ folder

V1__Create_person_table.sql

create table PERSON (
    ID int not null,
    NAME varchar(100) not null
);

This is just an example that read config data from a properties file and migrate these data into database.