Forum Discussion
Synapse Workspace Uplift to Fabric
It is not a straight forward way :
https://learn.microsoft.com/en-us/fabric/data-engineering/migrate-synapse-data-pipelines
https://learn.microsoft.com/en-us/fabric/data-engineering/migrate-synapse-overview
In some cases, manual interventions needs to be done
Thanks for your reply. I will wait If someone share their personal experience about how they did it. Thanks
Super UserHi max_mrc ,
You can consider Spectral Core for migrating synapse warehouse to fabric.
https://azuremarketplace.microsoft.com/en-us/marketplace/apps/spectralcore.sqltran?tab=overview
1. Data Migration From Synapse Dedicated pool
Option 1:
Managed table - you can use copy activity to move to lakehouse/warehouse
Unmanaged table - Copy data to onelake using spark or copy activity and write to lakehouse
Option 2:
Spectral Core
Option 3:
AzCopy, Azure storage explorer
2. Schema Migration From Synapse Dedicated pool
Option 1:
Export dacpac file from synapse dedicated pool and use MS Fabric Migrate(Preview) option to push to warehouse
Option 2:
Spectral Core
3. Synapse pipeline Migration
You need to recreate your SHIRs as OPDGs and virtual network enabled Azure IRs as Virtual Network Data Gateways.
You need to recreate pipelines, connections.
4. Notebook Migration
Spark version to be same.
Manually change the folders as Fabric doesn't support folders in notebook
Option 1:
you can export notebooks from Azure Synapse (.ipynb) and import them to Fabric (manually).
Option 2:
you can use a script to export notebooks from Azure Synapse and import them to Fabric using the API. You can refer semantic link labs.
Regards,
Srisakthi