Azure SQL Managed Instance Setup

Azure SQL Managed Instance is a scalable cloud database service that combines SQL Server database engine compatibility with all the benefits of a fully managed platform as a service. Azure SQL Managed Instance combines features that are available both in Azure SQL Database and the SQL Server database engine, providing a native virtual network (VNet) implementation. It supports traditional SQL Server database engine logins and logins integrated with Azure AD.

To start using Datical DB with Azure SQL Managed Instance, you need to configure Azure SQL Managed Instance:

1. Ensure that you have an Azure subscription or a free account created and that you set up Azure SQL Managed Instance. If you are new to Azure SQL Managed Instance, create an Azure SQL Managed Instance.

2. Install the latest version of Datical DB driver and plugins using the Datical DB GUI or CLI:

• GUI

To install Datical DB drivers, go to Help > Install New Software > Available Software and enter http://update.datical.com/latest/thirdparty/ in the pop-up window.

• CLI

Open the CLI and run the following command:

For example:

Composite archive (Windows and Linux):

Extracted archive (Windows and Linux):

See Also

• https://datical-cs.atlassian.net/wiki/spaces/DDOC/pages/2244771861

• https://datical-cs.atlassian.net/wiki/spaces/DDOC/pages/2245263381

• https://datical-cs.atlassian.net/wiki/spaces/DDOC/pages/2245394445

• Azure REST API reference

• Configure and manage Azure AD authentication with Azure SQL

• master Database

• Automated backups - Azure SQL Database & SQL Managed Instance