Installing on Azure SQL Database

[james-camacho-tel360]

From looking through the other Issues I think I know the answer, but submitting this Issue just to be sure. We'd like to use this to test the views we've written for ETL pipelines to ensure that the logic in the views will output the correct data. We want to include this in our Azure Pipelines so as we make changes to our views we can test the changes to verify there won't be any breaking changes with out business logic. When trying to run prepareserver.sql we've run into some errors:

Quick Google search indicates this permission is not available on Azure SQL Database, which makes sense given it's a Cloud Compute resource. So the questions are, is tSQLt compatible with Azure SQL Database? If so, what are the exact steps to get it working?

[peterbud]

Version https://tsqlt.org/download/tsqlt/?version=1-0-5873-27393 works with Azure SQL, as described at the download page

In azure Pipelines/ CI environment however I'd suggest to use a simple official SQL Server docker image for running unit tests with tSQLt - this is also working great.