Forum Discussion

XavierYan's avatar
XavierYan
New Member
1 year ago
Solved

Mirrored Sql Server Database Failed: Internal system error occurred.

When I try use the fabric mirroring to copy data from a on-premises sql server database, I followed the tutorial to create an on-premises data gateway and enable the cdc of database, and make sure th...
Mirrored Azure SQL Database
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    Hello XavierYan 

     

    On-premises SQL Server is unsupported for direct Fabric mirroring

     

    The native feature only works with:
    • Azure SQL Database
    • Azure SQL Managed Instance


    Not sure which tutorial you are following 

     

    please accept the answer if this is helpful 

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi XavierYan  ,
    Thanks for reaching out to the Microsoft fabric community forum.
    As nilendraFabric mentioned on premises sql server is not supported yet and if you do want to ingest your data into Fabric, as a workaround you may use traditional methods of ingesting data into fabric Like Data pipelines. Create a data pipeline within Microsoft Fabric to extract data from your on-premises SQL Server. Use the copy activity to transfer data into Fabric, employing incremental load patterns as needed.

    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
    Thanks and Regards

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi XavierYan ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.