Generate data script from fabric warehouse

[DiKi-I]

Hi 

is it possible to generate data script from fabric warehouse.

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

What will the easiest to migrate data?

I am not able to see the task option in ssms while connecting warehouse 

[NandanHegde · Accepted solution]

The most easy way to sync the data from 1 fabric warehouse to another would be to create a simple data pipeline with copy activity to copy from 1 warehouse to another.

Based on my understanding, generate scripts via SSMS is not available as of today

[v-aatheeque]

Hi @DiKi-I 

 I wanted to follow up on your inquiry regarding migrating data between Fabric warehouses. I provided some guidance on using a data pipeline with copy activity for this process, and I wanted to check in to see if you had any further questions or if you needed additional assistance.

If you could provide an update on your progress or any challenges you're facing, it would be greatly appreciated. Your feedback is important, and it helps us ensure that you receive the support you need.
If the issue is resolve accept the solution.

Thank you for your understanding, and I look forward to your response!

Best regards,
Atheeq.

[v-aatheeque]

Hi @DiKi-I 

I wanted to follow up on your question about migrating data between Fabric warehouses. I previously shared some guidance on using a data pipeline with copy activity for this process, and I wanted to see if you had any additional questions or if there’s anything else you’d like help with.

It would be great if you could share an update on your progress or let me know about any challenges you’re encountering. Your feedback helps us ensure you get the right support.

If your issue has been resolved, please consider marking the response as the accepted solution so it can help others as well.

Thank you, and I look forward to hearing back from you!

Best regards,
Atheeq

[v-aatheeque]

Hi @DiKi-I 

I wanted to check in regarding your question about migrating data between Fabric warehouses. Earlier, I shared some guidance on setting this up using a data pipeline with copy activity.

Do you have any follow-up questions, or is there anything else you’d like help with? It would be great to hear how things are going on your end and if you’ve run into any challenges along the way. Your feedback helps us make sure you get the right support.

If your issue has already been resolved, please consider marking the response as the accepted answer  this can also help others who might be facing the same situation.

Thank you, and I look forward to your update!

[Adityakumar]

1. Direct SSMS generate scripts feature isn't available for Fabric warehouses.
2. Traditional backup/restore operations aren't supported across tenants
3. Task option in SSMS is intentionally disabled for Fabric warehouse.

You can use below approach.

• Azure Data Factory
  --> Create linked services
  --> Use copy activity
  --> Schedule migration jobs

Happy to provide more information if needed. If this solved your question, consider leaving kudos