Forum Discussion
Synapse DB to Fabric migration
Hi All,
How can we migrate synapse DB to Fabric. what are the steps to follow and limitations.
Thanks in advance.
Hi BADDULA ,
For steps on how to migrate to Microsoft Fabric:
- Create a Fabric workspace and link it to your existing Azure Data Lake Storage account.
- Import existing notebooks, Spark jobs into the Fabric workspace.
- Update references to external tables or files using the OneLake syntax.
For more detailed information, please refer to the document below, which provides three common scenarios.
Here are some limitations to consider:
- Performance may vary depending on data types and data source latency.
- Migration may require scaling up resources temporarily to aid speed and efficiency.
More detailed information can be found in this document:
Azure Synapse dedicated SQL pools to Fabric Migration - Microsoft Fabric | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
4 Replies
Hi BADDULA ,
For steps on how to migrate to Microsoft Fabric:
- Create a Fabric workspace and link it to your existing Azure Data Lake Storage account.
- Import existing notebooks, Spark jobs into the Fabric workspace.
- Update references to external tables or files using the OneLake syntax.
For more detailed information, please refer to the document below, which provides three common scenarios.
Here are some limitations to consider:
- Performance may vary depending on data types and data source latency.
- Migration may require scaling up resources temporarily to aid speed and efficiency.
More detailed information can be found in this document:
Azure Synapse dedicated SQL pools to Fabric Migration - Microsoft Fabric | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!Hi BADDULA ,
Is my follow-up just to ask if the problem has been solved?
If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?
Thank you very much for your cooperation!
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!Depends where you want to Migrate to Fabric like lakehouse or warehouse
Hi BADDULA ,
Migrating Synapse DB to Microsoft Fabric isn’t a one-click process today, and limitations typically surface around schema compatibility, collation differences, pipelines, and orchestration.
That said, it’s absolutely achievable with the right migration approach to minimize manual effort and avoid common pitfalls. We’ve helped teams streamline Synapse → Fabric migrations using tooling that accelerates schema alignment and data movement.
If you’d like to explore a faster, structured way to handle this, feel free to reach out at [email protected] — happy to share a quick demo.
