ReadyRoll tSQLt Unit Test SQL Azure database

dawidp

I can't seem to deploy tSQLt framework to SQL Azure database - 0001_Install_tSQLt.sql script from the tutorial: https://documentation.red-gate.com/display/RR1/Tutorial:+Running+tests+in+Readyroll+with+tSQLt+Adapter because SQL Azure doesn't seem to support EXEC sp_configure 'clr enabled', 1;RECONFIGURE; configuration anymore.

Any recommendations on running Unit Tests in SQL Azure?

AdamB

I'm afraid Azure indeed no longer supports CLR integration, which tSQLt requires to run, so at the moment there is no way to run Unit Tests with tSQLt on Azure.

MGibson

If we have tSQLt in our in premise SQL Server database how do we move these to Azure?
Do we have to remove them?
If so how do we run our database unit tests, and we have a lot of them, on Azure DB?

AdamB

It looks as though tSQLt tests can now be run on Azure. However, the statement EXEC sp_configure 'clr enabled', 1;RECONFIGURE; is not supported on Azure - if you want to run database unit tests on Azure, you will need to ensure that your scripts don't contain this. There is an issue in the tSQLt repoing about updating their documentation to clarify things.