If by supporting you mean generating SQL statements the program at present does not go that far. All that is offered is creating the ER diagrams that are by its abstract nature DBMS independent.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Generating SQL from ERD is on to-do list but the manpower is rather a scarce resource now.
I am not sure of advantages of putting the save files into a database. The current XML based format offers all advantages of text based data and still may be used to run some queries using XPath or XQuery. I think that eventually XML will catch up with many standard routines traditionally offered by databases. And of course any more serious work on this subject would require more manpower.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
With friends from work, we have prepared generator for scripting MSSQL from ER(IE) Diagram as template for "Documentation generator..".
I can share this solution, but we use some custom modifications of ERD profile (added constraintcheck, UK index, schema and some of our solutions).
I think, this must be first discussed with Janusz.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It sounds quite interesting. Generating Sql was demanded on several occasions and generating SQL code with a documentation template is quite an original idea but should be easy to modify and be adapted to a specific DBMS if needed. So definitely it is worth looking at and I think both ERD profiles could coexist with some renaming etc.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I didn't find a list of Supported DBMSs by the ERD module of starUML or
WhiteStarUml.
does this kind of list exist?
Thanks
Tal
If by supporting you mean generating SQL statements the program at present does not go that far. All that is offered is creating the ER diagrams that are by its abstract nature DBMS independent.
View and moderate all "General Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
Why not saving on a Database instead of flat files? ;-)
The Crazy
Generating SQL from ERD is on to-do list but the manpower is rather a scarce resource now.
I am not sure of advantages of putting the save files into a database. The current XML based format offers all advantages of text based data and still may be used to run some queries using XPath or XQuery. I think that eventually XML will catch up with many standard routines traditionally offered by databases. And of course any more serious work on this subject would require more manpower.
With friends from work, we have prepared generator for scripting MSSQL from ER(IE) Diagram as template for "Documentation generator..".
I can share this solution, but we use some custom modifications of ERD profile (added constraintcheck, UK index, schema and some of our solutions).
I think, this must be first discussed with Janusz.
It sounds quite interesting. Generating Sql was demanded on several occasions and generating SQL code with a documentation template is quite an original idea but should be easy to modify and be adapted to a specific DBMS if needed. So definitely it is worth looking at and I think both ERD profiles could coexist with some renaming etc.