I was wondering if it is possible to get the list of Databases and tables associated with them from a Azure SQL Server using an ARM template

Question

I was wondering if it is possible to get the list of Databases and tables associated with them from a Azure SQL Server using an ARM template

Pratyusha N 0

Is it possible to get the list of databases and associated tables from Azure SQL Server via an ARM template .
If yes, please do share sample templates .

Thanks

Vahid Ghafarpour 23,205 Reputation points Moderator

2023-05-23T04:07:14.1533333+00:00

I don't think so. ARM templates are used for deploying and managing Azure resources, such as virtual machines, storage accounts, and databases. They primarily focus on provisioning and configuring resources rather than querying or retrieving data.

To retrieve the list of databases and associated tables from Azure SQL Server, you would typically use programming languages or tools that can connect to the SQL Server instance and execute queries. Some options for achieving this include:

Azure PowerShell: You can use Azure PowerShell cmdlets like Get-AzSqlServer and Invoke-AzSqlQuery to connect to Azure SQL Server and execute queries to retrieve the desired information.

Azure CLI: Azure CLI also provides commands for interacting with Azure SQL Server. You can use the az sql server and az sql db commands to fetch the required details.

Azure Management Libraries: You can leverage Azure Management Libraries for various programming languages such as .NET, Python, and Java to programmatically connect to Azure SQL Server and query the databases and tables.
SSingh-MSFT 16,276 Reputation points Moderator

2023-05-24T11:25:08.6133333+00:00

Hi
Pratyusha N •,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

1 answer

Your answer

Vahid Ghafarpour 23,205 Reputation points Moderator

2023-05-23T04:07:14.1533333+00:00

I don't think so. ARM templates are used for deploying and managing Azure resources, such as virtual machines, storage accounts, and databases. They primarily focus on provisioning and configuring resources rather than querying or retrieving data.

To retrieve the list of databases and associated tables from Azure SQL Server, you would typically use programming languages or tools that can connect to the SQL Server instance and execute queries. Some options for achieving this include:

Azure PowerShell: You can use Azure PowerShell cmdlets like Get-AzSqlServer and Invoke-AzSqlQuery to connect to Azure SQL Server and execute queries to retrieve the desired information.

Azure CLI: Azure CLI also provides commands for interacting with Azure SQL Server. You can use the az sql server and az sql db commands to fetch the required details.

Azure Management Libraries: You can leverage Azure Management Libraries for various programming languages such as .NET, Python, and Java to programmatically connect to Azure SQL Server and query the databases and tables.
SSingh-MSFT 16,276 Reputation points Moderator

2023-05-24T11:25:08.6133333+00:00

Hi
Pratyusha N •,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Answer 1

Hi
Pratyusha N •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to get the list of databases and associated tables from Azure SQL Server via an ARM template.

Export the ARM template:

Please try to open Export Template Option from the Left Panel of the Azure SQL Database Server pane as shown below:

User's image

This template generated would give all the Databases associated with the Azure SQL database server.

You may download the same by the option present at the top.

Azure Resource Explorer:

The second option to see the ARM template from existing resources is to use the Azure Resource Explorer. You can easily find it at https://resources.azure.com/

User's image

Additionally, you may see the Databases of SQL Server through portal as shown below:

User's image

Hope this helps.

Let us know if you have further queries.

Thank you.

Share via

I was wondering if it is possible to get the list of Databases and tables associated with them from a Azure SQL Server using an ARM template

1 answer

Your answer