Forum Discussion

DiKi-I's avatar
DiKi-I
Post Partisan
1 year ago
Solved

Migrate fabric warehouse data

Hi, How I can migrate my fabric warehouse data to another tenant? I  have to move everything to client tenant.
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi DiKi-I ,

     

    We cannot generate scripts after connecting SSMS , but still we can generate scripts from Fabric Warehouse itself using download sql database project as shown below:



    As of now, Fabric Warehouse does not support generating data scripts for data. A recommended approach is to create two Azure service principles, grant them access to the respective workspaces, and use ADF pipelines with Copy Data activities to move data from one tenant to another. 

    Below is the link for another workaround: 
    Solved: Re: MS Fabric migration between tenants - Microsoft Fabric Community 


    If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

    Thank you.

Mrunaal's avatar
Mrunaal
Helper I
6 months ago

DiKi-I ,

Cross-tenant migration of Fabric Warehouse data is a scenario many teams face when moving to a client environment, and it is achievable with the right migration and transfer approach rather than manual exports.

 

We’ve helped organizations handle tenant-to-tenant moves smoothly with structured tooling and automation — happy to show you how in a quick demo. Reach me at [email protected]