Store Sage CRM data in Azure SQL Database

The Sage CRM Setup provides a new option Connect to a Microsoft Azure SQL solution. When performing a new Sage CRM install, you can use this new option to connect to a Microsoft Azure SQL Database server, create a new database, and store Sage CRM data in it.

Sage CRM supports the following Azure SQL solutions and resource types:

Supported solution

Supported resource type
Microsoft Azure SQL Database Database server

Before running the Sage CRM Setup, make sure that the target Azure SQL Database server exists.

To create a new Azure SQL Database server compatible with Sage CRM: 

  1. Go to https://portal.azure.com/#create/Microsoft.AzureSQL.

  2. Under SQL databases, from the Resource type list, select Database server.

  3. Select Create and follow the steps to create a new Azure SQL Database server.

    At the moment Sage CRM does not support any other Azure SQL solutions and resource types.

Consider the following limitations:

  • You cannot use the Sage CRM Setup to select an existing database in Azure SQL. At the moment, the Setup can only create a new database on an existing Azure SQL Database server.

  • Sage CRM Setup cannot migrate data from an existing on-premise Microsoft SQL Server database to Microsoft Azure SQL.

For more information about Microsoft Azure SQL Database, see What is Azure SQL Database?.

For a complete list of supported database software, see the Sage CRM 2022 R1 Hardware and Software Requirements published on the Sage CRM Help Center.