Introducing Unit Testing for SQL Server Database Projects
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.