Forum Discussion

wanwar's avatar
wanwar
Icon for Helper I rankHelper I
1 year ago
Solved

Mirroring on-prem SQL Server database

We started a new mirrored db in fabric pointing to an on-prem SQL Server database. CDC is enabled on the db and on couple of tables (for testing). Replication starts and shows 2 selected tables but n...
data engineering
  • wanwar's avatar
    wanwar
    1 year ago

    Turned out cdc_capture and cleanup jobs were not created on the on-prem server for some reason, manually created those with cdc_enable_table SP, now Fabric mirroring is up and running

v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
1 year ago

Hi wanwar,

Thank you for the update. We will now proceed to close this ticket. If you have any further queries or require assistance in the future, please feel free to raise a new ticket in the community forum.

We appreciate your engagement and support.

 

 

Thanks,

Prashanth Are

MS fabric community support