Skip to content
Advertisement

SQLCMD or SQLPACKAGE on linux?

I am using ubuntu docker image as build agent on Azure Devops. I need to apply some DDL SQL scripts on Azure SQL DB. What tool I should use – SQLCMD or SQLPackage, or something else and why?

Thanks in advance

Advertisement

Answer

So in order to install SQLPackage I followed this tutorial. It got installed, however it did not work in Azure DevOps – just loading endlessly but no error, nothing. Finally I decided to go with Python (pyodbc) to connect to SQL DB and perform certain actions – Reference, MSSQLODBC driver.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement