ADO task for go-sqlcmd execution

microsoft / go-sqlcmd

The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads)

https://learn.microsoft.com/sql/tools/sqlcmd/go-sqlcmd-utility

MIT License

343 stars 60 forks source link

ADO task for go-sqlcmd execution #29

Open dzsquared opened 2 years ago

dzsquared commented 2 years ago

examples here: https://github.com/microsoft/azure-pipelines-tasks

current sqlcmd task: https://github.com/microsoft/azure-pipelines-tasks/tree/master/Tasks/SqlAzureDacpacDeploymentV1

shueybubbles commented 2 years ago

Once we have pushed sqlcmd to the various package managers, how much value does a native ADO task add compared to just running a script that installs it?

dzsquared commented 2 years ago

This might be better served as a discussion thread right now - but I have seen instances where a task template assists in making using a command line tool easier. It's not about installing go-sqlcmd but running it on queries/files.