SQL Test in Azure

Dana

I am unable to install the SQL Test framework in my development Azure SQL database. Is there a version that works in Azure?

Eddie D

Hi Dana,
Thank you for your forum post.

With regards to Azure, is this a SQL Instance you have created on a Virtual machine running on Azure, in that you can turn on / off options for the SQL Instance? Or this is a database running hosted on the Azure platform?

When you add a database to SQL Test, SQL Test will:
•Install the tSQLt framework on the database
Installing the framework adds a number of stored procedures, functions and a SQL CLR object to the database. You use the framework to implement unit tests in T-SQL.
For more information about the objects in the framework, see tSQLt User Guide.
•Set TRUSTWORTHY ON for the database
•Enable SQL CLR for the server

Do you have the security permissions to set TRUSTWORTHY ON for the database? Also, do have the security permissions to enable SQL CLR on the SQL Server Instance?

Many Thanks
Eddie