Forum Discussion

KKOMMAL's avatar
KKOMMAL
New Member
2 months ago
Solved

Fabric SQL- Good to have features

HI ,

I have started using MS Fabric and i see some of the useful features for data engineering activiites still needs to be added. 

 

Currently, Microsoft Fabric SQL Database does not provide an option to generate schema scripts (DDL only) or schema and data scripts (DDL + INSERT statements), similar to SQL Server Management Studio (SSMS). This makes migration, backup, and workspace-to-workspace database movement challenging.
 
Could Microsoft consider adding a "Generate Scripts" feature for Fabric SQL Databases to support exporting objects and data for easier migration and disaster recovery scenarios? 
  • KKOMMAL's avatar
    KKOMMAL
    2 months ago

    Thank you.

     

    Yes, i think we can try with .net SDK way of genrating backup or dacpac files and restore it . But if we have direct options like "generate Scripts", "Back Up"  and "Extract/Export Datatire applications" for the users. 

6 Replies