Configure Teamcity to handle SQL Test unit testing


I am using SQL Test to create some unit tests in SQL Server. And I integrated with Teamcity so that on a build, it auto runs the tSQLt tests.

The issue is that we plan to create hundreds of unit tests for all our store procs. And we don't want to run all of the unit tests each time we check in code and whereby Teamcity runs a build + runs the unit tests.

Is there a way to configure the integration build to only run new unit tests that are checked in?

Or is the practical solution to check in without Teamcity auto running the tSQLt unit tests? Thereby, just manually run the new test cases on the DEV server (after check in). An extension of this is to run a batch nightly to run ALL the unit tests on DEV, etc.

Thoughts appreciated.

Please sign in to leave a comment.