use matrix and init to start services
version: '{build}'
+init:
+ - cmd: net start %SQL%
+
environment:
JAVA_HOME: C:\Program Files\Java\jdk1.8.0
matrix:
- - mssql_jdbc_test_connection_properties: jdbc:sqlserver://localhost:1433;instanceName=SQL2008R2SP2;databaseName=master;username=sa;password=Password12!;
-
- - mssql_jdbc_test_connection_properties: jdbc:sqlserver://localhost:1433;instanceName=SQL2016;databaseName=master;username=sa;password=Password12!;
+ - SQL: MSSQL$SQL2008R2SP2
+ mssql_jdbc_test_connection_properties: jdbc:sqlserver://localhost:1433;instanceName=SQL2008R2SP2;databaseName=master;username=sa;password=Password12!;
-services:
- - mssql2008r2sp2
- - mssql2016
+ - SQL: MSSQL$SQL2016
+ mssql_jdbc_test_connection_properties: jdbc:sqlserver://localhost:1433;instanceName=SQL2016;databaseName=master;username=sa;password=Password12!;
install:
- ps: Write-Host 'Installing JCE with powershell'
