Installing tSQLt

Question

Post reply

Installing tSQLt

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
January 7, 2015 at 8:11 pm

#74779

Comments posted to this topic are about the item Installing tSQLt

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Robert.Sterbal SSCrazy Points: 2855 More actions · Answer 1

A quick edit:

Soundforge.net

should be:

Sourceforge.net

gotqn SSC Veteran Points: 277 More actions · Answer 2

As far as I know Red Gate SQL Test is based on this.[/url]

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 3

Robert.Sterbal (1/7/2015)
A quick edit:
Soundforge.net
should be:
Sourceforge.net

Thanks

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 4

gotqn (1/8/2015)
As far as I know Red Gate SQL Test is based on this.SQL Test[/url]

Red Gate's SQL Test isn't based on this. It provides a GUI view of the tSQLt framework in your database.

Nakul Vachhrajani SSChampion Points: 10294 More actions · Answer 5

Our team did evaluate tSQLt framework for a data comparison project that we undertook a while ago. What we found was that tSQLt simply started to hang up for very long periods of time (we would wait for hours and ultimately kill it) when attempting to process a large amount of data (>10,000 records) and was especially bad if we had non-relational data (e.g. XML) on the record.

Our fall back was a comparison using RedGate SQL DataCompare (which worked like a charm, by the way :-))

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com

Follow me on
Twitter: @sqltwins

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 6

Your tests shouldn't be processing that much data. Use test data that represents what you want to test, which should be a few documents.

This isn't really built for scale/performance testing.

James Zimmerman SSC Veteran Points: 297 More actions · Answer 7

As of the 1/31/2016 release you needn't set TRUSTWORTHY to ON.

http://tsqlt.org/748/tsqlt-v1-0-5873-27393-release-notes/

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 8

Steve Jones - SSC Editor

SSC Guru

Points: 736173

March 19, 2016 at 11:43 am

#1866280

Good catch and thanks

Bruceo SSCrazy Points: 2152 More actions · Answer 9

Hello all,

I know this is an old thread but any feedback would be appreciated.

I am busy implementing tSQLt in my SSDT project.

I am considering a dedicated database approach, in that each developer has their own copy of the db to develop on.

Does anyone have any thoughts / advice as to where the tSQLt framework should sit in terms of the database it is installed on?
Do you advise it being installed in your dev database or a separate unit tests database?

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 10

This needs to be in the database in which it will work. I don't think you can set this in a separate database.

Bruceo SSCrazy Points: 2152 More actions · Answer 11

Ok great. Thanks Steve, I appreciate your feedback.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 12

With SQLServer 2017 or the current Azure SQL Managed Instance, you also need to set configuration clr strict security to 0 !
( it is 1 by default !! )

exec sp_configure 'clr strict security', 0; reconfigure;

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me