Forum Discussion

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

Generate data script from ssms for fabric warehouse

is it possible to generate data script for warehouse tables? I need to export the data to another tenant,
Need Help
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi DiKi-I,

    Thank you for reaching out to the Microsoft Fabric Forum Community. 

    As of now, Fabric Warehouse does not support generating data scripts. 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 your reference: 
    Solved: Re: MS Fabric migration between tenants - Microsoft Fabric Community 

     

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

     

    Thank you. 

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
1 year ago

Hi DiKi-I,

I hope you had a chance to review the solution shared earlier. If it addressed your question, please consider accepting it as the solution — it helps others find answers more quickly.
If you're still facing the issue, feel free to reply, and we’ll be happy to assist further.

 

Thank you.