Mirroring your Azure SQL Business Central Database
The article discusses the feature of mirroring Azure SQL databases into Microsoft Fabric. This feature allows for near real-time mirroring of data updates, deletions, and insertions from Azure SQL databases to Microsoft Fabric. The article provides a step-by-step guide on how to enable this feature, including enabling "System Assigned Managed Identity" and allowing public access to the Azure SQL server. The article also mentions some limitations of the mirroring feature, such as a limit of 500 tables and restrictions on column names with certain characters. Overall, mirroring Azure SQL databases can be a useful feature for analytics and working with Business Central data.
Article 8m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time