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
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( 'email@example.com', # Your user 'my_password', # Your password ) sql_client = SqlManagementClient( credentials, subscription_id )
Some operations in the ARM APIs require a one-time registration of the provider with your subscription.
Use the following code to do the registration. You can use the same credentials you created in the previous section.
from azure.mgmt.resource.resources import ResourceManagementClient resource_client = ResourceManagementClient( credentials, subscription_id ) resource_client.providers.register('Microsoft.Sql')
You can get a fully functional SQL servers/databases sample from the AzureSample Github repository: https://github.com/Azure-Samples/sql-database-python-manage