Forum Discussion
How migrating a SQL dwh into Fabric
Hi pmscorca
There are some functional differences between the data warehouse in Azure SQL and the data warehouse in Fabric. You'll need to assess whether all of the features you are currently using are available at Fabric before you migrate. There is currently no dedicated tool to migrate an overall data warehouse solution. You might need to break the migration into parts. Here are some suggestions:
- Tables: You can export the schema and data from your Azure SQL database and import them into Fabric. This process typically involves exporting data to a format like Parquet and then importing it into Fabric.
- ADF Pipelines: You might need to recreate your Azure Data Factory (ADF) pipelines in Fabric’s Data Factory. While there isn’t a direct migration tool for ADF pipelines, you can manually recreate them using the same logic and activities.
- Stored Procedures: Stored procedures can be migrated by exporting the T-SQL code and then recreating them in Fabric. Some adjustments might be necessary to ensure compatibility.
- Databricks Notebooks: Notebooks can be exported from Azure Databricks and imported into Fabric. You may need to adjust the code to align with Fabric’s environment and capabilities.
You might want to find more information from the following documentations:
Migrate to Data Factory - Microsoft Fabric | Microsoft Learn
Comparison between Fabric and Azure Synapse Spark. - Microsoft Fabric | Microsoft Learn
As of now, the migration might be time consuming and not so easy. You might need to recreate or develop some things to make it work well.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi pmscorca
There are some functional differences between the data warehouse in Azure SQL and the data warehouse in Fabric. You'll need to assess whether all of the features you are currently using are available at Fabric before you migrate. There is currently no dedicated tool to migrate an overall data warehouse solution. You might need to break the migration into parts. Here are some suggestions:
- Tables: You can export the schema and data from your Azure SQL database and import them into Fabric. This process typically involves exporting data to a format like Parquet and then importing it into Fabric.
- ADF Pipelines: You might need to recreate your Azure Data Factory (ADF) pipelines in Fabric’s Data Factory. While there isn’t a direct migration tool for ADF pipelines, you can manually recreate them using the same logic and activities.
- Stored Procedures: Stored procedures can be migrated by exporting the T-SQL code and then recreating them in Fabric. Some adjustments might be necessary to ensure compatibility.
- Databricks Notebooks: Notebooks can be exported from Azure Databricks and imported into Fabric. You may need to adjust the code to align with Fabric’s environment and capabilities.
You might want to find more information from the following documentations:
Migrate to Data Factory - Microsoft Fabric | Microsoft Learn
Comparison between Fabric and Azure Synapse Spark. - Microsoft Fabric | Microsoft Learn
As of now, the migration might be time consuming and not so easy. You might need to recreate or develop some things to make it work well.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi, thanks for your reply.
I underline that the notebooks are hosted in the Azure Databricks service and not in a Synapse Spark pool.