dbcodeio / public

The Power of Databases, The Convenience of VS Code: All in One Place
24 stars 1 forks source link

Export Schema/structure and data #94

Open devpkr1 opened 1 week ago

devpkr1 commented 1 week ago

Hi Mike,

I have a few suggestions for the context menus of both Database and Table.

For the Database context menu, adding options like Dump Structure, Dump Structure with Data, and Import SQL would be useful. These options would facilitate exporting the database structure and data to an SQL file and importing database structure and data from an SQL file. (Screenshot attached)

Image

For the Table context menu, I suggest adding options such as Dump Structure, Dump Structure with Data, Import from SQL and CSV, and Generate Mock/Test Data. These additions would streamline exporting, importing, and generating test data directly within the table context.

Thanks Pradeep

mikeburgh commented 1 week ago

Yes, something I plan to add, it's a bit complex as I want to use the database native tools to do it so the export is 100% accurate and things are not missed when scripting tables etc