Home Projects Jobs Clientele Contact


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: UU tools

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

Alexey Parshin,

Authoright © Total Knowledge: 2001-2008