Connecting the Dots of Azure SQL CICD Part 3: Testing with tSQLt

Prerequisites

Refer to part 1, part 2 for the prerequisites.

• git
• A GitHub account
• Visual Studio Code
• Docker
• .NET Core SDK

Check out the blog post here.

And start by forking this project!

Using the tsql tutorial

Example Repository Contents

The repository consists of two Database Projects (.sqlproj), a dacpac with tSQLt installed, a GitHub Actions workflow and some supporting files for database setup/creation and running the tSQLt tests.

The Code Project

This project was created by using the built-in schema compare tools in Azure Data Studio to extract the database objects and create .sql files from them.

It is separated out into object type folders in the FinancialApp schema.

The Test Project

The Test project contains the dacpac with tSQLt installed as well as the tSQLt tests (in the demoTest.sql file). It also has a reference to the Code project so that with a single publish, both projects with be deployed into a new database.

Known Issues

At this time, tSQLt will not install into an Azure SQL Edge container database but local development/change management is still possible.