SQL Server

With SQL Server we have to decide if we are going to use the sqlserver17 or the default older one.

sqlserver17

To setup to use sqlserver17 we should set the databasePlatformName to sqlserver17 at either the ebean.databasePlatformName> level or at ebean.test.sqlserver.databasePlatformName> level.

ebean:
  databasePlatformName: sqlserver17  ## only using sql server
  test:
    platform: sqlserver # h2, postgres, mysql, oracle, sqlserver
    ddlMode: dropCreate # none | dropCreate | migrations
    dbName: test
    sqlserver:
      #collation: SQL_Latin1_General_CP1_CS_AS  ## use an explicit collation
      #collation: default                       ## use the sql server default

When testing against multiple database platforms put databasePlatformName: sqlserver17 under sqlserver like the example below:

ebean:
  test:
    platform: sqlserver # h2, postgres, mysql, oracle, sqlserver
    ddlMode: dropCreate # none | dropCreate | migrations | create
    dbName: test

    sqlserver:
      databasePlatformName: sqlserver17         ## put here when testing multiple platforms
      #collation: SQL_Latin1_General_CP1_CS_AS  ## use an explicit collation
      #collation: default                       ## use the sql server default

The above will use the following defaults:

username:	{databaseName}
password:	SqlS3rv#r
port:	1433
url:	jdbc:sqlserver://localhost:{port};databaseName={databaseName}
driver:	com.microsoft.sqlserver.jdbc.SQLServerDriver
image:	microsoft/mssql-server-linux:{version}