Table quotas in SQL MI DB Mirroring

[billgraffis]

Hello,

Is there a plan to support mirroring of databases with more than 500 tables in the future? We average 800 - 1500 tables per database and this would help us greatly.

Thanks!

[v-huijiey-msft · Accepted solution]

Hi @billgraffis ,

The maximum number of tables that can be mirrored into Fabric is 500 tables. Any tables above the 500 limit currently cannot be replicated.

Limitations and Behaviors for Fabric Mirrored Databases From Azure SQL Database - Microsoft Fabric |...

With 800-1500 tables per database, this limit is really challenging.

You can follow the updates on roadmap:

Microsoft Fabric and Power BI release plan documentation - Microsoft Fabric | Microsoft Learn

You can also submit feedback to the official on Home.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!