This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
| Summary: | Export schema to SQL DDL | ||
|---|---|---|---|
| Product: | db | Reporter: | Roman Mostyka <romanmostyka> |
| Component: | Code | Assignee: | Libor Fischmeistr <lfischmeistr> |
| Status: | NEW --- | ||
| Severity: | blocker | CC: | chrizzly, pjiricka |
| Priority: | P2 | ||
| Version: | 8.2 | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | ENHANCEMENT | Exception Reporter: | |
|
Description
Roman Mostyka
2008-12-12 14:52:57 UTC
Reassigned to new owner. This is this more or less provided by "Show SQL script for CREATE" and "Show SQL script for INSERT" but it would be very comfortable to be able to do it directly from the database tree for selected tables or the whole database. An Import schema from sql would be very nice too ! I changed the version to 8.2 because this is still a problem and not implemented yet. I know the context menu "grab structure" but there are to many steps. Right click on table -> grab structure -> choose a folder where you want to save the table_name.grab file -> e.g. delete the table -> right click on Tables -> Recreate table -> use the grab file and you can edit the SQL DDL. Toooo many steps. Better: Right click on table -> grab DDL structure to clipboard (Or whatever) -> you have the SQL DDL statement for creating table in the clipboard. DataGrip, the DB IDE from JetBrains did this and it is very handy. Regards Chris I'm working on the feature. With my feature it should be possible to rightclick on a table (or more) and then choose "View DDL/SQL". Then a little dialog will open (Like the one for Show SQL script for CREATE" in the result view, but directly in the tree as some mentioned. I will provide 2 Actions: "View DDL/SQL -> Will provide the CREATE TABLE SQL statement inside a dialog for one or more tables" "Copy DDL/SQL -> Will copy the CREATE TABLE SQL statement for one or more tables which you can select inside the Database tree" Cheers Chris |