Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Tool to transform db schema into DDL for different databases

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

From: David Fetter <david_at_fetter.org>
Date: Tue, 17 Jan 2006 23:28:07 -0600
Message-ID: <vP6dnaU1gqV6TFDenZ2dnUVZ_sKdnZ2d@speakeasy.net>


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@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
Received on Tue Jan 17 2006 - 23:28:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US