Create an Azure SQL managed instance on Azure Arc

  • บทความ
  • 2 นาทีในการอ่าน

Prerequisites

Before you can proceed with the tasks in this article you need to have:

Create an Azure SQL Managed Instance

To view available options for create command for SQL Managed Instance, use the following command:

az sql mi-arc create --help

To create a SQL Managed Instance, use az sql mi-arc create. See the following examples for different connectivity modes:

az sql mi-arc create -n <instanceName> --k8s-namespace <namespace> --use-k8s

Example:

az sql mi-arc create -n sqldemo --k8s-namespace my-namespace --use-k8s

Note

Names must be less than 13 characters in length and conform to DNS naming conventions

When specifying memory allocation and vCore allocation use this formula to ensure your performance is acceptable: for each 1 vCore you should have at least 4GB of RAM of capacity available on the Kubernetes node where the SQL managed instance pod will run.

If you want to automate the creation of SQL instances and avoid the interactive prompt for the admin password, you can set the AZDATA_USERNAME and AZDATA_PASSWORD environment variables to the desired username and password prior to running the az sql mi-arc create command.

If you created the data controller using AZDATA_USERNAME and AZDATA_PASSWORD in the same terminal session, then the values for AZDATA_USERNAME and AZDATA_PASSWORD will be used to create the SQL managed instance too.

Note

If you are using the indirect connectivity mode, creating Azure SQL Managed Instance in Kubernetes will not automatically register the resources in Azure. Steps to register the resource are in the following articles:

View instance on Azure Arc

To view the instance, use the following command:

az sql mi-arc list --k8s-namespace <namespace> --use-k8s

You can copy the external IP and port number from here and connect to it using your favorite tool for connecting to a SQL Sever/Azure SQL instance such as Azure Data Studio or SQL Server Management Studio.

At this time, use the insiders build of Azure Data Studio.

Next steps