Solved

MS SQL 2012: Unit Test for Database/Stored Procedures

Posted on 2013-01-14
3
702 Views
Last Modified: 2013-01-21
Hi!

I'm looking for some tips (best practice) how to unit test stored procedures in MS SQL 2012?

I found TSQLUnit and tSQLt, but is there any other or better ways to unit test a database.
0
Comment
Question by:ulf-jzl
3 Comments
 
LVL 38

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 250 total points
ID: 38776740
redgate stuff is expensive but awesome
http://www.red-gate.com/products/sql-development/sql-test/
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 250 total points
ID: 38783510
There's also an integrated Visual Studio option if you have the Data Tools installed:

http://blogs.msdn.com/b/ssdt/archive/2013/01/03/new-blog-post.aspx

The Red Gate products are generally top-notch - though expensive, they're awesome. In particular, it looks like the SQL Test product is actually a wrapper for tSQLt, using the APIs from that framework to execute the tests designed and managed in the Red Gate product.

I'm not sure what your situation is (if you're doing personal projects or working with a company), but I suspect the $300 price tag to pick up SQL Test is money well spent - if you're a developer making $75K, $300 is a single day's pay.
0
 

Author Closing Comment

by:ulf-jzl
ID: 38804267
Thx guys!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now