The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Creating schemas for mutliple RDBMS's

For my next project, I'm planning to support Oracle, SQL Server, and Firebird databases.  I'd like to develop the schema in a tool that supports creating the database schemas in the different formats listed.  Any suggestions for a tool that does this?

Sunday, November 26, 2006
 
 
You could try using Hibernate - http://www.hibernate.org/80.html

Sunday, November 26, 2006
 
 
Rails' Migrations could do what you want (you might have to write the firebird driver, but modifying one of the existing ones shouldn't be difficult).
The PHP DB abstraction library ADODB has an xml-schema implementation, not actually used that bit of ADODB though.

Sunday, November 26, 2006
 
 
I'm possibly showing my ignorance here - but does Hibernate actually create data models for you? I thought it concentrated on mapping classes to an existing data model.
Arethuza Send private email
Sunday, November 26, 2006
 
 
The Druid schema development tool supports different vendors with plugins, might be useful:

http://druid.sourceforge.net/
Chris Winters Send private email
Sunday, November 26, 2006
 
 
Berislav Lopac Send private email
Sunday, November 26, 2006
 
 
Thanks Berislav.  Toad Data Modeler looks like just what I need.

Sunday, November 26, 2006
 
 
www.datanamic.com

Database modeler that can create scripts for large number of databases, from one model.
moronica
Tuesday, November 28, 2006
 
 
You can also do this with "Database Designer" at ContextSoft:

http://www.contextsoft.com/products/dbdesign/
Herbert Sitz Send private email
Tuesday, November 28, 2006
 
 
PowerDesigner (from Sybase) does a good job of this, incl. the ability to define DBMS that the tool doesn't support out of the box.

http://www.sybase.com/products/modelingmetadata/powerdesigner
BillT Send private email
Wednesday, November 29, 2006
 
 
if you're using Eclipse, look at the database modeling plugin from Azzuri Clay.  I've created a few schemas where i'd initially specify ANSI-92 to prevent myself from picking any product-specific unique data types, then once i'm done, change the schema settings to MS SQL, DB2 and MySQL.  For all three, the generated scripts worked without a hitch.
Tim Send private email
Thursday, November 30, 2006
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz