- 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!
Sign In Now!
