Loading...
Loading...
Use when CI (GitHub Actions, Azure Pipelines, GitLab) runs integration tests against the Azure SQL Database container as a service: health check, registry secrets. For Testcontainers, use `azuresql-db-testing`.
npx skill4agent add microsoft/microsoft-sql azuresql-db-cimcr.microsoft.com/mssql/serverSELECT SERVERPROPERTY('EngineEdition')SERVERPROPERTY('Edition')sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latestACR_USERNAMEACR_PASSWORD--platform--platform linux/amd64ACCEPT_EULA=YMSSQL_SA_PASSWORDCREATE DATABASE appdbDatabase=appdbUSEUSEUSEMsg 40508masterUSEmasterDatabase=appdb-d appdbappdb/docker-entrypoint-initdb.d/*.sqlsqlcmd -d appdb -i seed.sqlServer=localhost,1433;Database=appdb;User Id=sa;Password=<MSSQL_SA_PASSWORD>;TrustServerCertificate=trueUser Id=Password=Database=Uid=Pwd=-CSQL_CONNECTION_STRINGappdbappdbdocker execname: integration
on: [push, pull_request]
jobs:
test:
runs-on: ubuntu-latest
services:
sqldb:
image: sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest
credentials:
username: ${{ secrets.ACR_USERNAME }}
password: ${{ secrets.ACR_PASSWORD }}
env:
ACCEPT_EULA: "Y"
MSSQL_SA_PASSWORD: ${{ secrets.MSSQL_SA_PASSWORD }}
SQLCMDPASSWORD: ${{ secrets.MSSQL_SA_PASSWORD }}
ports:
- 1433:1433
# Health check runs INSIDE the container; -b makes a SQL error set the exit
# code so transient startup errors (e.g. Msg 913) are retried, not masked.
options: >-
--health-cmd "/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -C -b -l 2 -Q \"SELECT 1\""
--health-interval 5s
--health-timeout 3s
--health-retries 20
--health-start-period 30s
steps:
- uses: actions/checkout@v7
# The engine does NOT auto-create databases. Provision appdb on master first,
# via docker exec into the service container (runner needs no sqlcmd).
- name: Provision appdb
run: |
CID=$(docker ps --filter "ancestor=sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest" --format '{{.ID}}')
docker exec "$CID" /opt/mssql-tools18/bin/sqlcmd \
-S localhost -U sa -C -b \
-Q "IF DB_ID('appdb') IS NULL CREATE DATABASE appdb;"
# Optional: seed appdb (no auto-seed). Copy the file in, then run it against appdb.
- name: Seed appdb
run: |
CID=$(docker ps --filter "ancestor=sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest" --format '{{.ID}}')
docker cp seed.sql "$CID:/tmp/seed.sql"
docker exec "$CID" /opt/mssql-tools18/bin/sqlcmd \
-S localhost -U sa -C -b -d appdb -i /tmp/seed.sql
- name: Run integration tests
run: |
# Tests connect to the USER database appdb, NOT master.
npm ci && npm run test:integration
env:
SQL_CONNECTION_STRING: "Server=localhost,1433;Database=appdb;User Id=sa;Password=${{ secrets.MSSQL_SA_PASSWORD }};TrustServerCertificate=true"credentials:ACR_USERNAMEACR_PASSWORD--health-cmd-l 2 -bdocker run-bDatabase=appdb| Secret | Purpose |
|---|---|
| Private preview registry sign-in (using the shared pull-only credentials provided to the Private Preview cohort; get them by signing up at https://aka.ms/sqldbcontainerpreview-signup; they may rotate) |
| Private preview registry sign-in |
| sa password for the engine; complex, 8+ chars |
services:- bash: |
printf '%s' "$ACR_PASSWORD" | docker login sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io --username "$ACR_USERNAME" --password-stdin
# Run the canonical start recipe below in this task.
env:
ACR_USERNAME: $(ACR_USERNAME)
ACR_PASSWORD: $(ACR_PASSWORD)
MSSQL_SA_PASSWORD: $(MSSQL_SA_PASSWORD)SQL_CONNECTION_STRINGservices:DOCKER_AUTH_CONFIGACCEPT_EULAMSSQL_SA_PASSWORD_UIMSSQL_SA_PASSWORDSQLCMDPASSWORDbefore_scriptdocker exec(
set +x
: "${MSSQL_SA_PASSWORD:?Set MSSQL_SA_PASSWORD in the CI secret store and map it into this step}"
export SQLCMDPASSWORD="$MSSQL_SA_PASSWORD"
HOST_PORT=1433; while lsof -nP -iTCP:"$HOST_PORT" -sTCP:LISTEN >/dev/null 2>&1; do HOST_PORT=$((HOST_PORT+1)); done
PLATFORM=(); case "$(docker info -f '{{.Architecture}}' 2>/dev/null)" in x86_64|amd64) ;; *) PLATFORM=(--platform linux/amd64);; esac
docker rm -f sqldb 2>/dev/null
docker run -d --name sqldb "${PLATFORM[@]}" -e "ACCEPT_EULA=Y" -e MSSQL_SA_PASSWORD -e SQLCMDPASSWORD \
-p "$HOST_PORT:1433" sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest
until docker exec sqldb /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -C -b -l 2 \
-Q "IF DB_ID('appdb') IS NULL CREATE DATABASE appdb;" >/dev/null 2>&1; do sleep 2; done
echo "ready on localhost,$HOST_PORT"
)credentials:docker loginACR_USERNAMEACR_PASSWORDACCEPT_EULA=YMSSQL_SA_PASSWORD-C -b -l 2appdbSQL_CONNECTION_STRINGDatabase=appdbUser Id=Password=Uid=Pwd=sqlcmdsqlcmd --versionmcr.microsoft.com/mssql/serverDatabase=appdbUSE appdbMsg 40508Database=appdb-d appdb/docker-entrypoint-initdb.d/*.sqlsqlcmd -d appdb -i--platform linux/amd64mcp__microsoft-learn__microsoft_docs_searchmcp__microsoft-learn__microsoft_docs_fetch