Forum Discussion

sgol's avatar
sgol
Advocate I
9 months ago
Solved

Mirroring for SQL Server 2025 installed on Azure VM

hi, we have got SQL server 2025 installed on a Azure VM. (recently updated from 2016 to 2025 of our instances). I need to bring this data into Onelake. what is the best possible option.   We prefe...
data engineering
  • Vinodh247's avatar
    Vinodh247
    9 months ago

    db mirroring is deprecated and not supported in sql 2025. For bringing data from SQL 2025 on Azure VM into OneLake, use ADF or fabric data pipelines with CDC/Change Tracking for near real time sync. If you need continuous replication, consider Transactional Replication or Azure Data Sync as supported alternatives.

  • ajayjmsft's avatar
    ajayjmsft
    5 months ago

    To clear the confusion here, Fabric Mirroring is the name of a new feature and different from Database Mirroring that SQL Server used to have form SQL Server 2005 and is now deprecated.

    Fabric Mirroring is used to mirror tables from source SQL Server (or Azure SQL Database, Managed Instance or Fabric SQL Database) to OneLake in Microsoft Fabric in near real-time in delta parquet format and can be used for analytics in Fabric. The support for using mirroring from SQL Server 2025 running on Azure Virtual Machines is currently not available. This is on our roadmap and coming soon. You can however mirror from other lower versions or from SQL Server 2025 outside Azure.

    To summarize:

    1. Mirroring from SQL Server 2016-2022 is supported from Azure VM or outside Azure hosted environments.

    2. Mirroring from SQL Server 2025 is currently supported from outside Azure hosted environments.

apturlov's avatar
apturlov
Super User
9 months ago

sgol It does seem like there is a bit of controversy in this topic. If you look at the Fabric Roadmap here Microsoft Fabric Roadmap you'll see that Mirroring for SQL Server 2025 was shipped and is in the public preview:

But in the documentation here Limitations of Fabric Mirrored Databases From SQL Server - Microsoft Fabric | Microsoft Learn it clearly states that Mirroring for SQL Server 2025 on Azure VM is not supported:

I suppose you need to experiement and see what is working.
On the other hand, the answer that Vinodh247 provided is not suported by a reference to a corresponding documentation, which would be very useful if it explained what is going on here:

v-venuppu I would vouch for more detailed answer on this topic with a link to some kind of documentation.