Database Setup through Flyway

For setting up database through flyway ensure you have installed the Flyway command line tool . To download the Flyway command line tool , visit the URL: https://flywaydb.org/getstarted/download

Note: Database setup through Flyway is applicable from release 7.1 onwards.

MySQL

Setup

Copy Mysql jdbc driver (mysql-connector-java-5.1.26-bin.jar) to Drivers folder under Flyway installation directory.

Configuration

Uncomment and modify following parameters in conf/flyway.conf file under Flyway installation directory :

• flyway.url = jdbc:mysql://<host>:<port>/<database>
• flyway.driver = com.mysql.jdbc.Driver
• flyway.user = <user name>
• flyway.password = <password>
• flyway.locations=filesystem:D:= <location path>

Setup Process

1. Extarct all the sql files from mysql.tar
2. Create a database with CHARSET as UTF8 and COLLATION as Unicode_CI.
3. Copy all the SQL files to be executed to sql folder under flyway installation directory.

   OR

   Uncomment and set flyway.locations=<sql script folder> in conf/flyway.conf file.

4. From command line use following command:
   1. flyway migrate

   

Microsoft SQL

Setup

Copy Microsoft SQL jdbc driver(sqljdbc4.jar) to drivers folder under flyway installation directory.

Configuration

Uncomment and modify following parameters in conf/flyway.conf file under flyway installation directory :

• flyway.url = jdbc:sqlserver://<host>:<port>;databaseName=database
• flyway.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
• flyway.user = <user name>
• flyway.password = <password>

• flyway.locations=filesystem:D:<location path>
• flyway.schemas=<Schema_Name>

Setup Process

1. Extarct all the sql files from sqlserver.tar
2. Copy all the SQL files to be executed in to sql folder under flyway installation directory.

   OR

   Uncomment and set flyway.locations=<sql script folder> in conf/flyway.conf file.

3. Open all the sql files and replace 'kpnsdb' with the new schema name as provided above.
4.  Run the following command to create a database.
   1. CREATE DATABASE [DATABASE_NAME] go
5. From command line, run the following command:
   1. flyway migrate -placeholders.KMS_SCHEMA=KMSDataBaseName

   

Oracle

Setup

Copy Oracle jdbc driver(ojdbc6.jar) to drivers folder under flyway installation directory.

Configuration

Uncomment and modify following parameters in conf/flyway.conf file under flyway installation directory :

• flyway.url = jdbc:oracle:thin:@//<host>:<port>:<sid>
• flyway.driver = oracle.jdbc.driver.OracleDriver
• flyway.user = <user name>
• flyway.password = <password>
• flyway.schemas=<schema>
• flyway.locations=filesystem:D:= <location path>

Setup Process

1. Extarct all the sql files from oracle.tar
2. Copy all the SQL files to be executed to sql folder under flyway installation directory.

   OR

   Uncomment and set flyway.locations=<sql script folder> in conf/flyway.conf file.

3. From command line use following command:

   C:\>flyway migrate -placeholders.KMS_DATA_TABLESPACE=<data_tablespace_Name> -placeholders.KMS_INDEX_TABLESPACE=<index_tablespace_Name> -placeholders.KMS_LOB_TABLESPACE=<lob_tablespace_Name>

   

DB2

Setup

Copy DB@ jdbc driver(db2jcc4.jar) to drivers folder under flyway installation directory.

Configuration

Uncomment and modify following parameters in conf/flyway.conf file under flyway installation directory :

• flyway.url = jdbc:db2://<host>:<port>/<database>
• flyway.driver = com.ibm.db2.jcc.DB2Driver
• flyway.user = <user name>
• flyway.password = <password>
• flyway.schemas = <schema name>
• flyway.locations=filesystem:D:= <location path>

Setup Process

1. Extarct all the sql files from db2.tar
2. Copy all the SQL files to be executed to sql folder under flyway installation directory.

   OR

   Uncomment and set flyway.locations=<sql script folder> in conf/flyway.conf file.

3. From command line use following command:

   c:\>flyway migrate -placeholders.KMS_DATA_TABLESPACE=<data_tablespace_Name> -placeholders.KMS_INDEX_TABLESPACE=<index_tablespace_Name> -placeholders.KMS_LOB_TABLESPACE=<lob_tablespace_Name> -placeholders.KMS_SCHEMA=<Schema_Name>

   

Rev	Author	Edits
8.0	AU	AU
7.2.5	AU	AU

Copyright © 2015 Temenos AG. All rights reserved.