What are the challenges you face when working across database platforms? Take the survey

Add a db (which already has tSQLt installed) to SQL Test

RedshiftRedshift Posts: 31 Bronze 3
I hadn't used SQL Test since installing it on my latest laptop.

I restored my development database, which already contains tSQLt into an instance and I can do all my normal development activities with the exception of using SQL Test.

The database doesn't appear in the list of dbs in the left hand pane of SQL Test and if I try to add it I get the following error message:-

SQL Test could not install the tSQLt Framework on mydatabasename

Any ideas how I add a database that already has tSQLt and a host of tests back into SQL Test.

I'm using SSMS v17.9.1


Best Answer

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Hi,  thank you for your forum post.

    What version of SQL Test and version of the tSQLt framework you are using?

    Is there any further on-screen information as to why the test framework could not be installed?

    I assume SQL CLR for the SQL Instance is enabled?

    The restored development database, dependent upon the version of SQL Test and version of the tSQLt framework, does the database have Set TRUSTWORTHY ON?

    • If using V1.7.3 or earlier, or a SQL 2017 or later database, Set TRUSTWORTHY ON for the database.  If using V1.7.4 or later, this setting is no longer a requirement on pre-SQL 2017 databases due to an upgrade of the tSQLt framework to V1.0.5873.27393.
    Many thanks

    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com


Sign In or Register to comment.