##Build Tasks This task allows users to to execute a SQL script ##Tasks Include Here is the complete parameter list for the PowerShell script: runOnAgent: will sqlcmd.exe run on the agent or on a different server; computerName: in case of running on a different server, the name of this server (exists in the VSO agent's network); credentialUserName: username for logging on to this server; credentialPassword: password for logging on to this server; serverName: name of the database server (including SQL instance name); databaseName: name of the database; useSQLAuthentication: use SQL authentication (or Windows authentication); userName: username of SQL account; password: password of SQL account; scriptName: full pathname of the SQL script. |