Downloads

tSQLt

Download the latest version of tSQLt and start unit testing your SQL code.

Download the version working with SQL 2005 (and currently Azure SQL Databases).

Source code

The tSQLt source code is hosted on GitHub and is also available as download, together with all of its tests.

Other downloads

We’ve also created an extensive set of snippets for Redgate’s SQL formatting tool, SQL Prompt, to make working with tSQLt easier.

External tools

There are several commercial SSMS extensions that make running tSQLt test cases more intuitive by providing a graphical user interface. Our preferred option is Redgate’s SQL Test, the official SSMS plug-in for tSQLt.

Redgate have put a lot of resources behind the development and continuing maintenance of the tSQLt framework, and use tSQLt themselves in their own development processes.

Share and Enjoy:

19 comments

Newest | Oldest

Llewellyn

There is a bug in your latest version of tsqlt.

You code in tSQLt.FakeTable refers to SP tSQLt.Private_RenameObjectToUniqueName which does not exist.

SP Private_RenameObjectToUniqueNameUsingObjectId is the only thing that comes close.

@sqlity moderator

@Llewellyn Try to uninstall and reinstall tSQLt from a fresh download.

funkysi1701

Just heard about TSQLT on .netrocks so will be giving it a try in the next few days

Public123

Please, consider moving downloable files outside of sourceforge, as sourceforge currently injects malware .

@sqlity moderator

@Public123, we are looking into this.

mudinz

tSQLt.AssertNotEquals is different compared with all other tests in that the command

'EXEC tSQLt.Fail @msg, @Message;' has @msg and @Message in reverse order.

@sqlity moderator

@mudinz , I added this to the backlog.

NestorSulikowski

Now that azure v12 supports CLR... can you make tSqLt work in sql azure? Thanks

@sqlity moderator

@NestorSulikowski I will look into it.

kmylapalli

Could somebody provide basic steps to integrate tsqlt in Visual studio please?

@sqlity moderator

@kmylapalli , this just came out and might be answering your question:

http://zogamorph.blogspot.co.uk/2014/07/integrating-tsqlt-with-sql-server-data.html

erik jansen

Hi,

Where can i post feature requests and/or issues detected?

Kind regards,

Erik

@sqlity moderator

@erik jansen You could send an email to the tSQLt google group: https://groups.google.com/forum/#!forum/tsqlt

Iain Elder

The download link is pointing back to this page: http://tsqlt.org/projects/tsqlt/files/latest/download?source=files Should that be a link to source forge?

Sebastian

Thanks for pointing this out. It is fixed now.

sudheer

like to download

Sebastian

I assume you were referring to the broken link? It is fixed now.

M Kalevik

Thanks

Sebastian

You are welcome :)