Application Lifecycle Management for SQL Server Database Development

Play Application Lifecycle Management for SQL Server Database Development
Sign in to queue


Come explore how to integrate SQL Server tooling in Visual Studio with Team Foundation Server to enable continuous integration and database unit testing. Getting SQL Server database projects to work with Team Foundation Server (TFS) has been a challenging task until now. Come and see how easy this process has become and how to integrate SQL Server database projects, database unit testing and continuous integration. This talk covers setting up SQL Server database project builds on TFS, adding database unit tests, and running unit tests using continuous integration.



Session Type:





Hall 8.0 Room F4



The Discussion

  • User profile image

    A must seen session. No Marketing, just what you need to know.

  • User profile image

    During the session we had several questions about database unit testing, in particular how to write data driven tests and how to implement mocking support. I mentioned that these were not built-in but that they could be supported by use of T4 templates (for data-driven testing) and use of the TSQLT framework (for mocking support). The blog posts that cover how to set this up are by Steven Wright. The main post is Integrating tsqlt with Team Foundation Build Services continuous buildating-tsqlt-with-team-foundation.html. This covers using T4 templates to generate the necessary database unit test classes (as shown in the demo) so that TSQLT tests can be run as part of Continuous Integration. The same process could be used to automatically output data-driven tests with a little bit of work. 


Add Your 2 Cents