- Direct SSMS generate scripts feature isn't available for Fabric warehouses.
- Traditional backup/restore operations aren't supported across tenants
- 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
