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.