Skip to content
Advertisement

how to get AzSql Database Import/Export Status using Python

I am trying to import a bacpac to azure sql database it runs for almost 2.5 hours, I need to get the status of this import job i.e. in-progress, complete etc using python. I know I can do it using Get-AzSqlDatabaseImportExportStatus -OperationstatusLink in powershell, but I want to do this using python.

Advertisement

Answer

You can use Python’s subprocess module to run Powershell commands.

The subprocess module allows you to spawn new processes, connect to their input/output/error pipes, and obtain their return codes.

You can store the Powershell script in any file and then read that file using subprocess.Popen method.

Example:

import subprocess, sys

p = subprocess.Popen(["powershell.exe", 
              "C:\Project\downloadSharePointFile.ps1"], 
              stdout=sys.stdout)
p.communicate()

Refer: Running Powershell script with Python, Executing PowerShell from Python

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