What are the challenges you face when working across database platforms? Take the survey

"ReadyRoll Run tSQLt Tests" task in VSTS: Errors looking for RunTests.sql and OutputResults.sql

Hello all,

I've set up a ReadyRoll database project in VS 2017 with tSQLt and some unit tests, which I'd like to have run during the build process. I'm using VSTS for CI build purposes, and have added the "ReadyRoll Run tSQLt Tests" task to the build definition.

Unfortunately, when the step is executed, the following error messages are produced. I've searched for info on where these two files need to be, and all I found was a StackOverflow thread that doesn't provide a definitive answer. Can someone enlighten me as to where the documentation on RunTests.sql and OutputResults.sql may be found? Where are the two files expected to be??
2017-12-17T14:14:51.6651310Z ##[section]Starting: Run tSQLt Tests on Unit Test Server
2017-12-17T14:14:51.6651310Z ==============================================================================
2017-12-17T14:14:51.6651310Z Task         : ReadyRoll Run tSQLt Tests
2017-12-17T14:14:51.6651310Z Description  : Run and output tSQLt database unit tests
2017-12-17T14:14:51.6651310Z Version      : 0.7.2
2017-12-17T14:14:51.6651310Z Author       : Redgate Software
2017-12-17T14:14:51.6651310Z Help         : [More Information](https://www.red-gate.com/readyroll)
2017-12-17T14:14:51.6651310Z ==============================================================================
2017-12-17T14:14:55.2214358Z ##[command]"sqlcmd.exe" -S sqldev.westus2.cloudapp.azure.com,1433 -d TestDB -U <username> -P <password> -i 'RunTests.sql'
2017-12-17T14:14:56.1965577Z Sqlcmd: ''RunTests.sql'': Invalid filename.
2017-12-17T14:14:56.3058822Z ##[command]"sqlcmd.exe" -S sqldev.westus2.cloudapp.azure.com,1433 -d TestDB -U <username> -P <password> -i 'OutputResults.sql' -o C:\agent\_work\4\s\tsqlt-test-results.xml
2017-12-17T14:14:56.3996295Z Sqlcmd: ''OutputResults.sql'': Invalid filename.
2017-12-17T14:14:57.3706897Z ##[error]Cannot find path 'C:\agent\_work\4\s\tsqlt-test-results.xml' because it does not exist.
2017-12-17T14:14:57.4332114Z ##[section]Finishing: Run tSQLt Tests on Unit Test Server


Sign In or Register to comment.