Is there a way to programmatically DROP a SQL Database in Azure?

Question

I am working on a process to automatically remove and add databases to Azure. When the database isn't in use, it can be removed from Azure and placed in cheaper S3 storage as a .bacpac.

I am using SqlPackage.exe from Microsoft as a PowerShell script to export and import these databases from and to Azure respectively in either direction. I invoke it via a Python script to use boto3.

The issue I have is with the down direction at step 3. The sequence would be:

Download the Azure SQL DB to a .bacpac (can be achieved with SqlPackage.exe)
Upload this .bacpac to cheaper S3 storage (using boto3 Python SDK)
Delete the Azure SQL Database (It appears the Azure Blob Python SDK can't help me, and it appears SQLPackage.exe does not have a delete function)

Is step 3 impossible to automate with a script? Could a workaround be to SqlPackage.exe import a small dummy .bacpac with the same name to overwrite the old bigger DB? Thanks.

Are you looking for a PowerShell Cmdlet to delete SQL database? — Gaurav Mantri
– Gaurav Mantri, Commented Mar 3, 2022 at 18:08
Yes, a Microsoft SQL Azure database, PowerShell or Python would be preferred to easily integrate into this script. — JoeD
– JoeD, Commented Mar 3, 2022 at 18:09

Gaurav Mantri · Accepted Answer · 2022-03-03 18:23:29Z

1

To remove an Azure SQL Database using PowerShell, you will need to use Remove-AzSqlDatabase Cmdlet.

To remove an Azure SQL Database using Azure CLI, you will need to us az sql db delete.

If you want to write code in Python to delete the database, you will need to use Azure SDK for Python.

answered Mar 3, 2022 at 18:23

Gaurav Mantri

137k17 gold badges247 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there a way to programmatically DROP a SQL Database in Azure?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related