VSTSDB Continuous Integration Practice: Installing our SQL Server Integration Test in the same field as the TFS Build Agent?

We are starting to use Visual Studio Database Edition 2010 (VSTSDB) for our continuous integration. In short, I have a nightly build that creates Deploy SQL and then run the script on SQL Server. In the end, I will run integration tests that will be performed in the newly created database after the assembly is deleted and the database is created.

I am wondering what is the best way to test SQL Server for assembly. This will either be the same flag as the TFS build agent, or on another system.

Any help is appreciated.

+3
source share
1 answer

The ideal place is an instance of SQL Server where you already have test databases.

I would try not to host it on a TFS build agent machine.

+1
source

Source: https://habr.com/ru/post/1746054/


All Articles