4: Testing during deployments

You can look to perform Unit Testing whilst your GitHub Actions workflow is running.

Microsoft provides documentation about verifying Database Code by Using SQL Server Unit Tests using Visual Studio.

However, you can also look to use the popular tSQLt Unit Testing framework instead.

Nikolai Thomassen wrote a great blog post on how to perform Azure SQL unit testing with tSQLt using Azure DevOps. In that post Nikola shows you how you can create a second database project solely that contains solely your tSQLt objects. Which provides you the flexibility to deploy as an additional project as required.

In addition, Sander Stad covered tSQL in a session called Start to See With tSQLt.

Those working with Azure DevOps as well can also look to use Azure Test Plans with GitHub.