sqlcmd - How to execute SQL in a PowerShell script as part of a Visual Studio Team Services build task? -


how execute sql against azure sql database part of powershell script in vsts build task in hosted agent?

there many tasks available build definitions: can execute powershell script

enter image description here

or deploy sql using dacpac or sqlcmd

enter image description here

or execute powershell on remote machines

enter image description here

but how execute sql part of powershell script? invoke-sqlcmd isn't available part of 'azure powershell' task.

i guess possible remote desktop app service, install sql server related bits there , use 'powershell on target machines' feel there has simpler way - perhaps i'm missing obvious

you can use azure sql database deployment task, there sql script file , inline sql script types.

enter image description here

note: can use hosted agent, not hosted vs 2017 agent.


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -