Arc Enabled Data Services – 5

In our previous post, we touched on the deployment of the Data Controller and being able to deploy via the Portal, Azure Data Studio, or CLI commands depending on whether you are implementing a directly or indirectly connected Data Controller.

Az Arcdata is a suite of CLI commands that allow command line management of the data controller and the Arc-enabled SQL Managed Instance once we have it configured.

A full list of CLI commands is available for az arcdata that allows for undertaking the following types of tasks:

• Managing Active Directory Authentication
• Creating and managing Arc Data Controllers
• Defining custom templates
• Creating and managing Arc-enabled SQL Managed Instances
• Creating and managing Failover Groups to provide DR/BC capabilities
• Restoring a database to the Arc-enabled SQL Managed Instance

Depending on the type of deployment you have implemented the Active Directory management is going to be slightly different due to directly connected mode utilizing Azure Active Directory and indirectly connected using Kubernetes authentication Active Directory for SQL endpoints.

The other component you will want to look at which will be different and you need to configure appropriately is the way you undertake patching/upgrades of the data controller versions. In a directly connected scenario, this can pull updated images directly from the Microsoft Container Registry (MCR). In Indirectly connected mode you will need to implement an approach to pull from the MCR and upload the images appropriately to your private container registry that your data controller has access to.

The same with usage data for billing purposes or logging and metrics data to upload into log analytics. Look at the export commands. Spend some time working through the commands based on your deployment scenario.