/
Azure SQL Managed Instance Setup

Liquibase Enterprise was formerly known as Datical DB.

Azure SQL Managed Instance Setup

Azure SQL Managed Instance support is available in 7.10 and later releases

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.

For more information, see Azure SQL Managed Instance.

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:

hammer installDrivers <driver_update_site>

For example:

hammer installDrivers http://update.datical.com/latest/thirdparty/

The update site can be either HTTP URL (as shown in the example) or directories on a file system.

Composite archive (Windows and Linux):

jar:file:/C:/Users/Pete/DaticalDBCompositeRepo-<release-version>.zip jar:file:/home/Users/Pete/DaticalDBCompositeRepo-<release-version>.zip

Extracted archive (Windows and Linux):

file:/C:/Users/Pete/DaticalDBCompositeRepo-<release-version>/ file:/home/Pete/DaticalDBCompositeRepo-<release-version>/

 

Azure SQL Managed Instance and the master Database

The master database records all the system-level information, including metadata, which is logon accounts, endpoints, linked servers, and system configuration settings. It is a best practice to keep your master database static.

When you use Azure SQL Managed Instance, you cannot update a master database, and it is not recommended to create objects in the master database. For example, if your master database is rebuilt, all objects will be lost. 

See Also

Related content

Copyright © Liquibase 2012-2022 - Proprietary and Confidential