I am using VS2010 command line tool (VSDBCMD) to deploy SQL projects to specific environments via batch file.
My batch file first builds the database project using a User ID and Password that the user enters. I then deploy the project using the newly created dbmanifest.
When I purposefully enter a wrong password, I get an error on the screen but vsdbcmd does NOT set the %ERRORLEVEL% to 1. In fact no error message from the deploy set the %ERRORLEVEL%.
How am I to check if the deploy fails?
This is how I am running it:%VS_DEPLOY_PATH% /a:Deploy /manifest:%TAG%\%%a\sql\debug\%%a.deploymanifest /cs:"Persist Security Info=True;User ID=%DB_USER%; Password=%DB_PASS%;Initial Catalog=%%a;Server=%SERVER%" /p:AbortOnFirstError=True /q+ /dsp:SQL /dd+
Any help is appreciated.
Thanks