powershell db copy

gistfile1.ps1

task BackupTestToQaDatabase {
	try {
		Invoke-Sqlcmd -InputFile $copySqlDatabase -ServerInstance $sqlserver -Database $databaseToBackUp -Username $databaseUsername -Password $databasePassword -QueryTimeout 240 -ErrorAction 'Stop'
	} catch {
		'##teamcity[buildStatus status='FAILURE' text='Build Failed']'
	}
}