Tool to facilitate the data migration to a Fabric SQL database

[pmscorca]

Hi,

I'd like to know if it exists some tools to facilitate the data migration to a Fabric SQL Database.

It seems that the Migration Assistant is specific for a data warehouse.

Many thanks

[mabdollahi]

@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.

[markf7962]

Wouldn't SqlPackage do this?

[Srisakthi]

Hi @markf7962 ,

Yes. Please refer this link

https://learn.microsoft.com/en-us/fabric/database/sql/sqlpackage

Regards,

Srisakthi

[maruthisp]

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

[Srisakthi · Accepted solution]

Hi @pmscorca ,

Please refer this document.

https://learn.microsoft.com/en-us/fabric/database/sql/sqlpackage

Regards,

Srisakthi