Tool to facilitate the data migration to a Fabric SQL database

pmscorca 

Since it is still in preview, there’s no dedicated migration tool like the Data Migration Assistant for it yet.

For now, the easiest ways to move data are:

• Use Dataflows Gen2 or Fabric Pipelines to pull data from your source (like SQL Server, Oracle, etc.) into the Fabric SQL DB.

• Or use notebooks with JDBC/ODBC to connect to the source and insert data.

• If you're already using ADF, you can set up a pipeline to copy data, though full support for Fabric SQL DB is still evolving.

So it’s not fully automated yet, but these options work depending on your setup.

Wouldn't SqlPackage do this?

Hi pmscorca ,

I don't think there is a tool. But from Azure Synapse dedicated sql pools to fabric dwh, below is the microsoft reference link:
https://learn.microsoft.com/en-us/fabric/data-warehouse/migrate-with-migration-assistant

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

pmscorca  Have you been able to migrate your data to Microsoft Fabric?

If not, I’m excited to share that we have a Gen AI-powered tool that simplifies migrating your existing data to Fabric. It helps harness the power of Gen AI to accelerate migration, reduce costs by up to 60%, speed delivery by 50%, and optimize your data estate.

If you’d like to learn more, feel free to reach out to me at [email protected]