Configure Jenkins to restore DB to a known dataset before running MsTest application Configure Jenkins to restore DB to a known dataset before running MsTest application jenkins jenkins

Configure Jenkins to restore DB to a known dataset before running MsTest application


REM restore DB (with REPLACE)SQLCMD -U user -P password -S .\SQLEXPRESS -Q "RESTORE DATABASE databasename FROM DISK='path to back file'" WITH REPLACE

You need to put this script in a "batch windows cmd" in Jenkins (replace the user, password, databasename, and path to back file with the correct values).