Fabric Mirroring vs Copy Job for a large SQL Server Database (+1,300 tables)

Summary

Power BI receives innovative data migration functionality that efficiently mirrors larger SQL Server databases.

Fabric: mirroring vs. copying for large SQL Server database

This article discusses how a company is considering replicating data from a large SQL Server database containing around 1,300 tables and over 1 million rows per table. They are weighing the option of using a mirrored SQL Server database in Fabric versus a Copy Job with a one-hour refresh. A notable limitation is that database mirroring reportedly supports only up to 500 tables, which poses a significant challenge.

Why this matters

For BI professionals, this underscores the need for strategic decision-making when handling large datasets. The choice between database mirroring and Copy Jobs is critical, especially for organizations working with complex data models. As the database technology market evolves, tools like Fabric can provide essential advantages in managing data volumes more efficiently. Competitors like Azure Data Factory offer alternatives, but they also come with their own limitations.

Concrete takeaway

BI professionals should keep a close eye on Fabric's capabilities, particularly when working with extremely large databases. Carefully select the technology that best aligns with your organization's requirements and the data volumes you manage.