1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
SQL Database Management
=======================
For general information on resource management, see :doc:`Resource Management<resourcemanagement>`.
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 <https://manage.windowsazure.com/#Workspaces/AdminTasks/SubscriptionMapping>`__.
See :doc:`Resource Management Authentication <quickstart_authentication>`
for details on handling Azure Active Directory authentication with the Python SDK, and creating a ``Credentials`` instance.
.. code:: python
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
|
