Re: UU tools

["Alexey Parshin" <alexeyp@gmail.com>]

Ok, seems like Umbrello has an export module API. I'd work on it.

2006/8/6, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com>:
> Yes, fixing SQL export module of Umbrello seems like most
> appropriate solution to the problem at hand.
>
> Anatoly Volynets wrote:
> > Correct me, if I'm wrong: Ilya things the program Alexey wants to write
> > (for 8-12 hrs) can serve as a module attached to Umbrello? I don't mind.
> > Total Knowledge sponsors this.
> > -Anatoly
> >
> > Ilya A. Volynets-Evenbakh wrote:
> >
> >> Well, I think right thing to do would be to stick with UML and umbrello
> >> format.
> >> And as for converting to real SQL, there is third option - fix Umbrello ;-)
> >>
> >> Alexey Parshin wrote:
> >>
> >>
> >>> Guys,
> >>>
> >>> I've just spent around 6 hrs digging for any tools we can use for
> >>> database ERD (entry relations diagram). I've found several tools, that
> >>> are good for something.
> >>> At short, there is no Open Source tools for Linux we can use out of
> >>> the box, and most popular tools for Windows Erwin and ErStudio don't
> >>> work under wine.
> >>> The closest candidates are Dia and Umbrello. They both are using a
> >>> sort of XML to store the diagram. Dia uses it's own format, and
> >>> Umbrello uses XMI that is a standard more or less.
> >>> Only Umbrello is capable to generate primitive SQL (create table
> >>> statements only) that isn't good enough for us. I'd like to have a
> >>> nice diagram we can all work with, easily convertable into the DDL
> >>> statements.
> >>>
> >>> I've an idea, however, to read the XMI, or DIA, or similar files and
> >>> convert 'em into SQL DDL we need, including table structure and
> >>> foreign keys. The program itself is going to be pretty simple - I can
> >>> make it for 8..12 hrs. The resulting project could be Open Source or
> >>> anything else - I don't really care at this point.
> >>>
> >>> I'm attaching the files from Dia (.dia), Umbrello (.xmi), and proposed
> >>> configuration for the xmi2sql convertor. Please, let me know if this
> >>> is something you want me to do, or may be Ilya has another solution.
> >>> Is any of this payable, BTW? I didn't count even an hour for last
> >>> several weeks..
> >>>
> >>> --
> >>> Alexey Parshin,
> >>> http://www.sptk.net
> >>>
> --
> Ilya A. Volynets-Evenbakh
> Total Knowledge. CTO
> http://www.total-knowledge.com


--
Alexey Parshin,
http://www.sptk.net