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. 

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

I have to migrate the data from fabric warehouse to another fabric warehouse in different tenant. 

  • collinq's avatar
    collinq
    Super User
    1 year ago

    Hey DiKi-I ,

    I do not believe there is a tenant to tenant for Fabric.  You might want to ask in the Database or Fabric forums as this one is for Power BI related questions.  To my knowledge, you have to export to notepad or whatever tool you want from Tenant one and then go to Tenant two and import from your tool.  So, it is a manual process.  BUt, again, maybe in the other forums they know something else.

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

      This question is more related to fabric. That's why I have posted this in Fabric community.

      • collinq's avatar
        collinq
        Super User
        1 year ago

        Hi DiKi-I ,

        Yes, I know that it can get confusing about which forum is which.  This is the Power BI forum (which is part of Fabric) but I think you will get a better response in the forums dedicated to Fabric.  These are the two I am referring to: