Other databases

The following examples demonstrate how to configure a connection to Microsoft SQL Server. Username and password fields are omitted for brevity. These fields are part of the platform installation guides.

Microsoft SQL Server with default instance

relution:
  database:
    type: mssql
    url: 'jdbc:sqlserver://localhost:1433;databaseName=relution'

Microsoft SQL Server with custom instance

relution:
  database:
    type: mssql
    url: 'jdbc:sqlserver://localhost\<INSTANCE>:1433;databaseName=relution'

Dedicated Liquibase DB user

By default the relution.database.* connection & credentials are used to perform all Liquibase changes, but a dedicated DB user can be configured to perform them.

First you create a new user in the database and assign him the corresponding DB permissions to perform DDL operations. Then you extend the Relution yaml configuration with the credentials like seen below:

spring:
  #datasource: # this is defined in relution.database.*
  liquibase:
    #default-schema: # this is defined in relution.database.*
    user: <liquibaseUser>
    password: <liquibaseUserPassword>