Azure SQL compatibility

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

The use of Azure SQL Managed Instance(MI) as the database.

Environment

CA Client Automation - 14.5

Resolution

We haven't certified Azure SQL Database. See the following compatibility matrix:

CA Client Automation - 14.5 > Supportability Matrix > Manager and Server Support > DSM Enterprise/Domain Manager - MDB Database Support

We do not have documentation regarding the pre-requisites as it is not certified.

Additionally note that the Azure SQL Database is a cloud platform that hosts the latest stable version of SQL Server:

What is the Azure SQL Database service?

"Azure SQL Database is a fully managed Platform as a Service (PaaS) Database Engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of SQL Server Database Engine and patched OS with 99.99% availability. ..."

In case the Azure SQL will host the latest stable version of SQL Server Database Engine, it might not be supported according to the Client Automation compatibility matrix.