On-Prem SQL Mirroring

[Srisakthi]

Hello Everyone,

I have a requirement to mirror on-prem sql db to Fabric. There is a documentation which detailed out on how to achieve this scenario.

https://support.fabric.microsoft.com/en-ca/blog/mirroring-sql-server-database-to-fabric?ft=All

The question which came to mind is

As per the above article it says us to do transactional repliacte to Azure SQL. Why cant we replicate to Fabric SQL Database instead of Azure SQL Database? In that case we can directly use Fabric SQL database right?

Regards,

Srisakthi

[dlevy · Accepted solution]

Hi @Srisakthi - Replication is an option when you need more discrete control of what is being replicated to Fabric.

For that article, the goal was to get an entire on-prem database mirrored into OneLake. We are working on a way to mirror directly from on-prem databases to OneLake. If this is your scenario, send me a direct message and I can pull the mirroring PM into the conversation to talk about preview opportunities. Azure SQL Database is a good choice there because it can support up to 100TB of space and can be optimized cost-wise to run full time. 

You can also replicate directly to Fabric SQL database. It is actually documented with Azure SQL here: 

https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database. Replicating directly to Fabric SQL database is a great option if you want to keep your data in a relational format. This option is more costly than just going to OneLake but there are optimizations that can help with that, like optimizing your replication schedule to maximize the time your database stays paused.