Re: Tool to transform db schema into DDL for different databases

<firestormua_at_yahoo.com> wrote in message news:1136819801.497185.161380_at_g14g2000cwa.googlegroups.com...
> Please help me folks .
> My goal is to find tool(s) that :
> 1. allows to edit ERD
> 2. allows syncronization between DB and ERD
> 3. generates database creation SQL for different databases from same
> ERD(Oracle, MSSQL, Postgress, MySQL)
> 4. Has Hibernate persistance support(can produce Hibernate java classes
> and mapping files)
> 5. Tool(s) are free or inexpensive (up to 1000).
> 6. Preferably it is one tool ( set of tools is ok as long as they do
> the job).
>
> Is there are any articles about developing schema that is good for
> different databases?
>

About five years ago, I liked Data Architect (in Sybase Power Designer) quite a lot. It did most of what you describe above, very well. It's support for Java classes was limited, and it was beyond the price range you mention. You might want to take a look at it anyway. Received on Tue Jan 10 2006 - 13:38:50 CET