4: Setting up unit testing

I have devised a way that you can do Unit Tests for dedicated SQL Pools using tSQLt.

It does require a SQL Server instance somewhere though and changing your database project so that the target platform is SQL Server.

Basically, you have to first create a dacpac for SQL Server and then deploy it to a SQL Server instance to perform your unit tests on.

Afterwards, you can make a copy of the database project in your pipeline and then change the DSP setting in the copied sqlproj file. Which will then change the target platform. I go into more detail about how to do this in a post called Deploy from one source to multiple SQL Server database types using GitHub Actions.

I cover this a bit more in another post I wrote called Unit tests for an Azure Synapse Analytics dedicated SQL Pool.