Mirroring your Azure SQL Business Central Database

Dynamics 365 Business Central

The article discusses the ability to mirror Azure SQL data into Microsoft Fabric in near real time.
To enable this feature, "System Assigned Managed Identity" and "Public access" with "Allow Azure services and resources to access this server" must be enabled on the Azure SQL server.
In Microsoft Fabric, under the "Data Engineering" section, users can select the "Mirrored Azure SQL Database (preview)" option to set up the mirroring process.
The option "Database Mirroring (preview)" in the Tenant settings of the admin portal must be turned on to access these features.
Users can choose to mirror all tables or select specific tables from the Azure SQL database for mirroring.
There are limitations to the mirroring process, such as syncing only 500 tables and restrictions on column names with certain characters.
The Fabric team is working on resolving the issue with column names containing invalid characters, potentially opening up mirroring options for Business Central online in the future.
Overall, mirroring Azure SQL databases into Microsoft Fabric offers valuable options for analytics and working with Business Central data.

Registered users can view the full text for FREE!