The following examples demonstrate how to configure a connection to
Microsoft SQL Server and
Oracle Database 11g. Username and password
fields are omitted for brevity. These fields are part of the platform
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'
Oracle 11g with SID
relution: database: type: oracle url: 'jdbc:oracle:thin:@localhost:1521:<SID>'
Oracle 11g with service name
relution: database: type: oracle url: 'jdbc:oracle:thin:@//localhost:1521/<SERVICE_NAME>'
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
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>