| View previous topic :: View next topic |
| Author |
Message |
wilhelmi
Joined: 02 Apr 2004
Posts: 1
|
|
Posted: Fri Apr 02, 2004 5:48 pm Post subject: Going from a Diagram to SQL (DDL)
|
|
|
Hello,
Is it possible to go from the Diagram to a SQL DDL script to manage the tables? I have looked through the docs but can figure out how to do it, am I missing something or is it not possible?
Thanks!
-Nate
|
|
| Back to top |
|
|
xavier
Site Admin
Joined: 14 Mar 2003
Posts: 81
|
|
Posted: Mon Apr 05, 2004 8:06 am Post subject:
|
|
|
Hi,
In your Navigator or your Package Explorer.
Select a Resource, Right-Click->New->Other...
A Wizard Selector is opened
Select Database on the Left Pane.
All the available Database Wizards are listed there.
Choose the Database Schema SQL Script wizard.
Regards.
Last edited by xavier on Fri Dec 17, 2004 9:38 am; edited 1 time in total
|
|
| Back to top |
|
|
codeword
Joined: 17 Dec 2004
Posts: 2
Location: Honolulu, HI
|
|
Posted: Fri Dec 17, 2004 3:17 am Post subject:
|
|
|
| xavier wrote: |
Hi,
In your Navigator or your Package Explorer.
Select a Resource, Right-Click->New->Other...
A Wizard Selector is opened
Select Database on the Left Pane.
All the available Database Wizards are listed there.
Choose the Database Schema SQL Script wizard.
Regards. |
I have tried to do this, but all it does is remove the changes from my schema.ods.xml file instead of add the SQL to the schema-db.sql file.
Is there something I am not doing?
I have gone through all the documentation and cannot find anything detailed about how to modify a diagram (like adding a new table) and having those changes at least show up in the schema-db.sql file.
|
|
| Back to top |
|
|
xavier
Site Admin
Joined: 14 Mar 2003
Posts: 81
|
|
Posted: Fri Dec 17, 2004 9:35 am Post subject:
|
|
|
Hi,
1 - The process of generating a SQL Schema only read the schema.
This is an XML process followed by a velocity template engine transformation.
Please open a request at our support desk if you experience a Schema corruption.
However, please give use more informations on your environment.
Operating System. GTK version if applicable.
Eclipse Version
EclipseUML Version
JDK Used
2 - To add a Table, you need to create and edit a diagram.
Everything is explained in our documentation
EclipseDatabase User Guide -> Modeling with Database Diagram Editor.
Regards.
|
|
| Back to top |
|
|
|
|