Forum Discussion
On-prem sql databases migration to fabric warehouse
We have an around 50 SQL databases that is residing on Microsoft SQL server. We want to migrate all these to Fabric Warehouse. Can i create a .bak and import/restore into Fabric Warehouse? If not, i would appreciate how i can achieve these. Thank you.
Hi mandania,
Thank you for reaching out in Microsoft Community Forum.
Thank you nilendraFabric for the helpful response.
As suggested by nilendrafabric, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Please continue using Microsoft community forum.
Regards,
Pavan.
4 Replies
Hi mandania,
Thank you for reaching out in Microsoft Community Forum.
Thank you nilendraFabric for the helpful response.
As suggested by nilendrafabric, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Please continue using Microsoft community forum.
Regards,
Pavan.Thank you for your support. Since there is no direct way to approach this , i was wondering MS Fabric has though about this issue and if they have in their roadmap to resolve it? The solution given is kin dof a "hot fix" but more solid approach is required here. i will accept the solution and thanks again for prompt reply.
Hello mandania
Microsoft Fabric Warehouse does not support the direct import of .bak files.
One alternative is to create .bacpac file --> import it to Fabric SQL DB ( bacpac file are supported) --> copy to WH
https://learn.microsoft.com/en-us/fabric/database/sql/sqlpackageHope this helps
ThanksnilendraFabric I have tried the .bacpac solution with Fabric SQL DB but right now its seems buggy as its not working. Thank you for you reply.
