Documentation:
By default, the test suite runs SQL Server in a container using TestContainers.
The container database binds to an arbitrary port to avoid conflicts. Nevertheless, you can force the usage of the standard SQL Server port (1433) with a flag:
mvn test -DcontainerFixedPort
You can start an external database:
docker run -t -i -p 1433:1433 -e TZ=Europe/Paris -e ACCEPT_EULA=Y -e SA_PASSWORD=A_Str0ng_Required_Password mcr.microsoft.com/mssql/server:2017-latest
Then run tests against it:
mvn test -Dconnection.uri=sqlserver://SA:A_Str0ng_Required_Password@localhost:1433
-
connection.uri
: configure the client to connect to the specified database