How to Migrate Tables, Views, Functions, and SP from Warehouse to warehouse in cross Tenants

[Vedanth]

Hi team,

I am working on migrating tables, views, functions, and stored procedures from one Fabric Warehouse to another across different tenants. Since this involves cross-tenant data movement, could you suggest the best approach to ensure a smooth and efficient migration?

[Srisakthi]

Hi @Vedanth ,

You can try as per below url

https://blog.fabric.microsoft.com/en-in/blog/simplify-your-warehouse-alm-with-dacfx-integration-in-g...

Regards,

Srisakthi

[v-prasare]

Hi @Vedanth, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @Vedanth, 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @Vedanth, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@NandanHegde , Thanks for your promt response.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[NandanHegde · Accepted solution]

The best way  to deploy the Fabric warehouse is via database project.

https://www.kevinrchant.com/2024/08/01/ci-cd-for-microsoft-fabric-data-warehouses-using-github-actio...