The Azure Quickstart templates are currently available in English
Deploy UDR and NSG to support Azure SQL Managed Instance and deploy the Managed Instance
Questo modello di Azure Resource Manager è stato creato da un membro della community e non da Microsoft. Ogni modello di Azure Resource Manager viene concesso in licenza ai sensi di un contratto di licenza a cura del proprietario e non di Microsoft. Microsoft non è responsabile dei modelli di Azure Resource Manager forniti e concessi in licenza da membri della community e non ne verifica la sicurezza, la compatibilità o le prestazioni. I modelli di Azure Resource Manager della community non sono supportati nell'ambito di alcun programma o servizio di supporto tecnico Microsoft e vengono resi disponibili COSÌ COME SONO senza garanzie di alcun tipo.
Parametri
| Nome parametro | Descrizione |
|---|---|
| location | Location for all resources |
| vnetResourceName | The name of the vnet |
| managedInstanceSubnetName | Managed Instance Subnet name |
| sqlManagedInstanceName | Name of the Azure SQL Managed Instance - must be globally unique, contain only lowercase letters, numbers and '-' |
| sqlManagedInstanceAdminLogin | Admin user for Managed Instance |
| sqlManagedInstancePassword | Admin user password - must be 16-128 characters, must contain 3 of uppercase, lowercase, numbers and non-alphanumeric characters, and cannot contain all or part of the login name |
| sqlManagedInstance-storageSizeInGB | Amount of Storage in GB for this instance |
| sqlManagedInstance-vCores | Number of vCores for this instance |
| sqlManagedInstance-licenseType | Type of license: BasePrice (BYOL) or LicenceIncluded |
| sqlManagedInstance-skuName | SKU NAME (GP_Gen4, GP_Gen5, BC_GEN5) |
| sqlManagedInstance-skuEdition | SKU Edition (GeneralPurpose, BusinessCritical) |
| sqlManagedInstance-hardwareFamily | Hardware family (Gen4, Gen5) |
| sqlManagedInstance-collation | SQL Collation |
| tags | Tags for the Managed Instance SQL resource. |
| _artifactsLocation | The location of resources, such as templates and DSC modules, that the template depends on |
| _artifactsLocationSasToken | Auto-generated token to access _artifactsLocation |
| vnetAddressRange | Address range for the virtual network in CIDR notation |
| managedInstanceNSGName | Name of the Managed Instance NSG |
| managedInstanceRouteTableName | Name of the Managed Instance Route Table |
| managedInstanceSubnetAddressRange | Managed Instance Subnet range |
| miManagementIps | List of MI management IP ranges |
Usa il modello
PowerShell
New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deploymentInstallare e configurare Azure PowerShell
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/demos/azure-sql-managed-instance/azuredeploy.json
Riga di comando
az group create --name <resource-group-name> --location <resource-group-location> #use this command when you need to create a new resource group for your deploymentInstallare e configurare l'interfaccia della riga di comando multipiattaforma di Azure
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/demos/azure-sql-managed-instance/azuredeploy.json