cs0815
cs0815

Reputation: 17418

Unit testing SQL Server stored procedures

I am trying to follow this:

Unit Testing SQL Server sproc

I am using Visual Studio 2010 but cannot find the option to add a unit test to the imported stored procedures - see this step:

Right-click one of the stored procedures, and click Create Unit Tests to display the Create Unit Tests dialog box.

Am I missing something? Thanks.

Upvotes: 2

Views: 2551

Answers (2)

SQLUnitTester
SQLUnitTester

Reputation: 1

After struggling with the "Create Unit Tests" being disabled it came down to this important point - so I deleted everything that would not build.

"...the project needs to build without errors or else the option will be grayed out. – Kevin Cunnane Dec 25 '13 at 14:05"

Upvotes: 0

Panagiotis Kanavos
Panagiotis Kanavos

Reputation: 131722

The link you provide is about SQL Server Data Tools, a separate download. You need to install SSDT and then create a Database Project

After installed, the context menu is only available in Visual Studio's SQL Server Object Explorer (which can be accessed as a window under the View menu). Expand your project's Programmability folder and then finally right click on Stored Procedures.

Upvotes: 4

Related Questions