Share via

Best Way to Sync/Mirror a Database Without Primary Keys to Azure Analytics (Fabric, Synapse, Databricks)?

Gnanasoundari 45 Reputation points
2025-05-30T12:58:06.2866667+00:00

I’m exploring solutions to sync/mirror an external database (SQL Server/Azure SQL DB) to Azure analytics services (Microsoft Fabric, Synapse, Databricks), but my source tables do not have primary keys (PKs).

Current Challenges:

  • Explored Synapse sync for azure sql have limitation for if source table doesn't have primary keys
  • Microsoft Fabric’s mirroring requires PKs for incremental syncs.
  • Need a reliable way to capture changes (inserts/updates/deletes) without PKs.

Questions:

  1. What is the best Azure-native solution for syncing PK-less tables?
SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  2. Erland Sommarskog 134K Reputation points MVP Volunteer Moderator
    2025-05-30T19:40:11.6066667+00:00

    Define primary keys?

    Preferably from the existing data.

    Was this answer helpful?