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

firestormua_at_yahoo.com wrote:
> 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?

Before you go diving in here, consider *very* carefully what you are about to do. When you decide to support more than one database back-end, you have taken on a giant architectural task up front and a Sisyphean task of maintenance. If supporting multiple database back-ends is not *the essential* feature of your project, stop now and choose one single back-end, and max out its capabilities.

Regards,
David.

-- 
David Fetter david_at_fetter.org http://fetter.org/
phone: +1 510 893 6100    mobile: +1 415 235 3778

Fascism should more properly be called corporatism, since it is the
merger of state and corporate power.
                                                    Benito Mussolini