tSQLt - Database Unit Testing for SQL Server

Database Unit Testing for SQL Server

  • Home
  • Docs
    • Documents
    • Quick Start
    • Articles
  • Training
  • Downloads
tSQLt » Downloads

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:
  • FacebookFacebook
  • TwitterTwitter
  • LinkedInLinkedIn
  • RedditReddit
  • StumbleUponStumbleUpon
  • TechnoratiTechnorati
  • PrintPrint
19 comments
  Livefyre
  • Get Livefyre
  • FAQ
Sign in
+ Follow
Post comment
 
Link
Newest | Oldest
Llewellyn
Llewellyn 5pts

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
@sqlity moderator 5pts

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

funkysi1701
funkysi1701 5pts

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

Public123
Public123 5pts

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

@sqlity
@sqlity moderator 5pts

@Public123, we are looking into this.

mudinz
mudinz 5pts

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
@sqlity moderator 5pts

@mudinz , I added this to the backlog.

NestorSulikowski
NestorSulikowski 5pts

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

@sqlity
@sqlity moderator 5pts

@NestorSulikowski I will look into it.

kmylapalli
kmylapalli 5pts

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

@sqlity
@sqlity moderator 5pts

@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
erik jansen 5pts

Hi, 

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

Kind regards,


Erik

@sqlity
@sqlity moderator 5pts

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

Iain Elder
Iain Elder 5pts

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
Sebastian 5pts

Thanks for pointing this out. It is fixed now.

sudheer
sudheer 5pts

like to download

Sebastian
Sebastian 5pts

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

M Kalevik
M Kalevik 5pts

Thanks

Sebastian
Sebastian 5pts

You are welcome :)

Navigation

  • Full user guide
  • Why you should use the tSQLt framework
  • How to get more out of tSQLt
  • Join the conversation
  • Downloads
  • Articles
  • Release Notes
  • New Logo
  • Training
  • Sponsors & Contributors
  • Why you should unit test SQL Server Code
  • Documents
    • Quick Start
    • tSQLt Tutorial
    • tSQLt Keyboard Shortcuts
    • Test Creation and Execution
      • NewTestClass
      • DropClass
      • RunAll
      • Run
      • RenameClass
    • Assertions
      • AssertNotEquals
      • AssertEmptyTable
      • AssertEquals
      • AssertEqualsString
      • AssertEqualsTable
      • AssertObjectExists
      • AssertResultSetsHaveSameMetaData
      • Fail
      • AssertObjectDoesNotExist
      • AssertEqualsTableSchema
      • AssertLike
    • Expectations
      • ExpectException
      • ExpectNoException
    • Isolating Dependencies
      • ApplyConstraint
      • FakeTable
      • SpyProcedure
      • FakeFunction
      • RemoveObjectIfExists
      • ApplyTrigger
      • RemoveObject

Links

  • tSQLt on GitHub
  • tSQLt Mailing List
  • twitter hashtag (#tsqlt)
  • tSQLt tag on stackoverflow.com
  • SQL Server Community on Slack (#tsqlt)

Sponsors

sqlity.net
redgate.com

A sqlity.net llc Web Property. | ©2010 - 2020, All Rights Reserved. | Privacy Policy | Terms of Use