az sql mi-arc
Commands
| Command | Description |
|---|---|
| az sql mi-arc endpoint | View and manage SQL endpoints. |
| az sql mi-arc create | Create a SQL managed instance. |
| az sql mi-arc update | Update the configuration of a SQL managed instance. |
| az sql mi-arc delete | Delete a SQL managed instance. |
| az sql mi-arc show | Show the details of a SQL managed instance. |
| az sql mi-arc get-mirroring-cert | Retrieve certificate of availability group mirroring endpoint from sql mi and store in a file. |
| az sql mi-arc upgrade | Upgrade SQL managed instance. |
| az sql mi-arc list | List SQL managed instances. |
| az sql mi-arc config | Configuration commands. |
| az sql mi-arc dag | Create or Delete a Distributed Availability Group. |
az sql mi-arc create
To set the password of the SQL managed instance, set the environment variable AZDATA_PASSWORD
az sql mi-arc create
Examples
Create an indirectly connected SQL managed instance.
az sql mi-arc create -n sqlmi1 --k8s-namespace namespace --use-k8s
Create an indirectly connected SQL managed instance with 3 replicas in HA scenario.
az sql mi-arc create -n sqlmi2 --replicas 3 --k8s-namespace namespace --use-k8s
Create a directly connected SQL managed instance.
az sql mi-arc create --name name --resource-group group --location location --subscription subscription --custom-location custom-location
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.
az sql mi-arc update
Update the configuration of a SQL managed instance.
az sql mi-arc update
Examples
Update the configuration of a SQL managed instance.
az sql mi-arc update --path ./spec.json -n sqlmi1 --use-k8s
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.
az sql mi-arc delete
Delete a SQL managed instance.
az sql mi-arc delete
Examples
Delete a SQL managed instance using provided namespace.
az sql mi-arc delete --name sqlmi1 --k8s-namespace namespace --use-k8s
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.
az sql mi-arc show
Show the details of a SQL managed instance.
az sql mi-arc show
Examples
Show the details of an indirect connected SQL managed instance.
az sql mi-arc show --name sqlmi1 --k8s-namespace namespace --use-k8s
Show the details of a directly connected SQL managed instance.
az sql mi-arc show --name sqlmi1 --resource-group resource-group
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.
az sql mi-arc get-mirroring-cert
Retrieve certificate of availability group mirroring endpoint from sql mi and store in a file.
az sql mi-arc get-mirroring-cert
Examples
Retrieve certificate of availability group mirroring endpoint from sqlmi1 and store in file fileName1
az sql mi-arc get-mirroring-cert -n sqlmi1 --cert-file fileName1
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.
az sql mi-arc upgrade
Upgrade SQL managed instance to the desired-version specified. If desired-version is not specified, the data controller version will be used.
az sql mi-arc upgrade
Examples
Upgrade SQL managed instance.
az sql mi-arc upgrade -n sqlmi1 --k8s-namespace arc --desired-version v1.1.0 --use-k8s
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.
az sql mi-arc list
List SQL managed instances.
az sql mi-arc list
Examples
List SQL managed instances.
az sql mi-arc list --use-k8s
Global Arguments
--debug
Increase logging verbosity to show all debug logs.
--help -h
Show this help message and exit.
--output -o
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
--query -q
JMESPath query string. See http://jmespath.org/ for more information and examples.
--verbose
Increase logging verbosity. Use --debug for full debug logs.