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.
source
share