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
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
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>