SQL Database Management

For general information on resource management, see Resource Management.

Create the management client

The following code creates an instance of the management client.

You will need to provide your subscription_id which can be retrieved from your subscription list.

See Resource Management Authentication for details on handling Azure Active Directory authentication with the Python SDK, and creating a Credentials instance.

from azure.mgmt.sql import SqlManagementClient
from azure.common.credentials import UserPassCredentials

# Replace this with your subscription id
subscription_id = '33333333-3333-3333-3333-333333333333'

# See above for details on creating different types of AAD credentials
credentials = UserPassCredentials(
    'user@domain.com',  # Your user
    'my_password',      # Your password
)

sql_client = SqlManagementClient(
    credentials,
    subscription_id
)

Servers/Databases sample

You can get a fully functional SQL servers/databases sample from the AzureSample Github repository: https://github.com/Azure-Samples/sql-database-python-manage