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

RedshiftRedshift Posts: 27 Bronze 2
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


Tagged:

Best Answer

  • Eddie DEddie D Posts: 1,700 Rose Gold 5
    Accepted Answer
    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



    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]

Answers

Sign In or Register to comment.