Skip to content

JetterMcTedder/AzureSQLDevOpsDemo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

94 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

Prerequisites

Refer to part 1, part 2 for the prerequisites.

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.

The Code Project

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.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages