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:
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.
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.
For more information, see Using the GUI and the Update Site to Install Datical DB on Windows Systems.
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
Roles and Permissions for Liquibase Enterprise and Azure SQL Managed Instance
Creating Connections in Liquibase Enterprise and Azure SQL Managed Instance
Packager backup and restore process for SQL Server and Azure SQL Managed Instance
The ephemeralConnectionRetryTimeout property for Azure SQL Managed Instance
Troubleshooting Issues with Active Directory Authentication and Azure Managed Instance
Automated backups - Azure SQL Database & SQL Managed Instance
Related content
Copyright © Liquibase 2012-2022 - Proprietary and Confidential