HomeНаука и техникаRelated VideosMore From: Microsoft Visual Studio

Introducing Unit Testing for SQL Server Database Projects

104 ratings | 39405 views
Unit testing is a core fundamental aspect of application development. But unit testing can and should be utilized when developing databases as well, to verify that changes have not regressed database functionality. Visual Studio 2013 provides SQL Server database unit tests as part of the testing infrastructure and in SQL Server Database Projects. In this video, you'll see how to create and execute database unit tests, and test scripts, in Visual Studio 2013, and then view the results.
Html code for embedding videos on your blog
Text Comments (16)
Andres Peña (1 month ago)
Cordial saludo Alguno encontro la solucion para habilitar la opción de prueba unitaria sobre el archivo sql? Estoy en Visual Studio 2017 Quedo atento
Henry Wyckoff (11 months ago)
There is an absence of available training on using SSDT to unit test SQL Database Projects. A "hello world" demonstration is insufficient. While "https://msdn.microsoft.com/en-us/library/jj851212(v=vs.103).aspx" takes a deeper cut, it is still insufficient. After all these years, I am truly shocked that where are no MVA or Pluralsight courses on this topic.
Matths K (2 years ago)
Is she a robot?
damarh (5 months ago)
or is she a dancer ?
ziqb (10 months ago)
reading robot
Prateek Yadav (3 years ago)
'Create Unit Test..' option is disabled in my case. Is there any workaround for same? I tried few things from Google but didn't help.
Zhe Lee (2 years ago)
yeah tthat's right~'
mario rodriguez (2 years ago)
Not sure if will help one year later :), but same happen in Visual Studio 2015, you just need to get your project build successfully with no errors, after this you will be able to create the unit test
mario rodriguez (2 years ago)
Not sure if will help one year later :), but same happen in Visual Studio 2015, you just need to get your project build successfully with no errors, after this you will be able to create the unit test
Soso Damana (2 years ago)
+李哲 did you ever find a solution to your problem. I am getting the same issue
Zhe Lee (3 years ago)
+Prateek Yadav Hey, I have the same problem as yours, have you got any solution?
NB Dev (3 years ago)
Nice intro :)
@Varum Meher Because it is being introduced in VS 2013
Varun Meher (4 years ago)
I am using VS2010 and SQL server 2008 R2
Varun Meher (4 years ago)
When I right click on the stored procedure in SQL Server object explorer, I don't have the create unit test option
mario rodriguez (2 years ago)
Not sure if will help 2 years later :), but same happen in Visual Studio 2015, you just need to get your project build successfully with no errors, after this you will be able to create the unit test

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.