Integration tests on the Azure SQL Database container with Testcontainers

Write integration tests that start a real Azure SQL Database container (Private Preview) from code, provision appdb, run the test against it, and tear the container down. This is the Azure SQL engine, not the SQL Server image.

This skill is about tests that manage their own engine lifecycle in-process (Testcontainers). It is DISTINCT from azuresql-db-ci, which wires the same engine into a CI pipeline as a service container via workflow YAML. If the goal is a CI job rather than in-code test setup, use azuresql-db-ci instead.

Verified on 2026-09-05 against the container image sqldbpreview-dpgaeqhmgphzd4bk.azurecr.io/azure-sql/db-dev:latest, reporting EngineEdition 5, Edition SQL Azure, build 12.0.2000.8. All six executable checks behind this skill passed: the engine identity, Msg 40508 for USE, that the engine inside the container listens on 1433 so a random mapped host port works, that connecting creates no database, the native VECTOR(n) type, and the /opt/mssql-tools18/bin tools the wait strategy invokes being present inside the image. The Testcontainers recipes themselves were not executed by that run.