Create SQL Managed Instance - Azure Arc using Azure Data Studio

Je li ova stranica od pomoći?

Imate dodatne povratne informacije?

Povratne informacije će biti poslane kompaniji Microsoft: pritiskom na dugme za slanje, vaše povratne informacije će se koristiti za unapređivanje proizvoda i usluga kompanije Microsoft. Pravila privatnosti.

This document walks you through the steps for installing Azure SQL Managed Instance - Azure Arc using Azure Data Studio

Prerequisites

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

• The client tools installed.

  Tools include Azure Data Studio and the Azure CLI.

  For Azure Data Studio, install extensions for Azure Arc, and PostgreSQL (depending on data services).

  For the Azure CLI, install extension arcdata.

• An Azure Arc data controller installed.

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

Create Azure SQL Managed Instance on Azure Arc

• Launch Azure Data Studio

• On the Connections tab, Click on the three dots on the top left and choose "New Deployment"

• From the deployment options, select Azure SQL Managed Instance - Azure Arc

  Note

  You may be prompted to install the appropriate CLI here if it is not currently installed.

• Accept the Privacy and license terms and click Select at the bottom

• In the Deploy Azure SQL Managed Instance - Azure Arc blade, enter the following information:

  • Enter a name for the SQL Server instance
  • Enter and confirm a password for the SQL Server instance
  • Select the storage class as appropriate for data
  • Select the storage class as appropriate for logs
  • Select the storage class as appropriate for backups

Note

Note: Starting with the February release, a ReadWriteMany (RWX) capable storage class needs to be specified for backups. Learn more about access modes If no storage class is specified for backups, the default storage class in kubernetes is used and if this is not RWX capable, the Arc SQL Managed Instance installation may not succeed.

• Click the Deploy button

• This should initiate the creation of the Azure SQL Managed Instance - Azure Arc on the data controller.

• In a few minutes, your creation should successfully complete

Connect to Azure SQL Managed Instance - Azure Arc from Azure Data Studio

• View all the Azure SQL Managed Instances provisioned, using the following commands:

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

Output should look like this, copy the ServerEndpoint (including the port number) from here.

Name          Replicas    ServerEndpoint     State
------------  ----------  -----------------  -------
sqlinstance1  1/1         25.51.65.109:1433  Ready

• In Azure Data Studio, under Connections tab, click on the New Connection on the Servers view
• In the Connection blade, paste the ServerEndpoint into the Server textbox
• Select SQL Login as the Authentication type
• Enter sa as the user name
• Enter the password for the sa account
• Optionally, enter the specific database name to connect to
• Optionally, select/Add New Server Group as appropriate
• Select Connect to connect to the Azure SQL Managed Instance - Azure Arc

Next Steps

Now try to monitor your SQL instance