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 Reputation points
2023-05-22T12:47:48.1266667+00:00

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

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
    2023-05-23T05:41:21.84+00:00

    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.

    0 comments No comments