ReadyRoll tSQL Unit Tests and VSTS

dawidp

I followed the Tutorial: Running tests in Readyroll with tSQLt Adapter for setting up a Visual Studio ReadyRoll database project, and a separate Unit Test project, and got it working fine. Now I would like to run the tests on VSTS as part of automatic deployment. Following this Tutorial: Visual Studio Team Services , I see a step for deploying the database, but not a step for deploying the Unit Test project.

What is the recommended approach for this, and how do I ensure that the tests are deployed only to my QA environment but not production?

AdamB

We've added a new documentation page that describes how to set up tSQLt tests with VSTS. To ensure the tests are only deployed to QA, you should add a new environment to your release definition. The QA environment should include tasks to run the tSQLt tests, whilst the Production environment should not.

Please let us know if you have any problems getting this working.