Re: tool for DB design

On Fri, 25 Nov 2005, Nikolay Samokhvalov wrote:

> dbvis isn't the thing what I need. Or I'm blind and cannot find where
> I can draw ER/UML diagram then transform it to physical, then obtain
> SQL code. Or, just physical->SQL. Please correct me if I'm wrong.

Nikolaym, it's worth to look on Enterprise Architect
http://www.sparxsystems.com/products/ea_purchase.html
It's not free, but not so pricy.

>
> On 25/11/05, Tino Wildenhain <tino(at)wildenhain(dot)de> wrote:
>> Am Freitag, den 25.11.2005, 02:25 +0300 schrieb Nikolay Samokhvalov:
>>> Please, suggest any free/opensource tool for DB design under Linux. I
>>> need following: ER (or UML)-diagram -> physical diagram -> SQL code (I
>>> don't even dream about reverse transformation...) Quite good example
>>> of such tool is Sybase PowerDesigner (which supports Postgres), but
>>> AFAIK it runs only under win and costs $...
>>
>> dia can do this and I guess a lot of other tools.
>> For the reverse check out db visualizer (dbvis)
>> http://www.minq.se/products/dbvis/
>>
>> Which has a very nice ER-view.
>> (With autorouting, which many tools, even the $$$-ones
>> miss)
>>
>> ++Tino
>>
>>
>
>
> --
> Best regards,
> Nikolay
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83