RE: [OJB-developers] Vendor neutral DDL scripting Tool

[Bram M. <br...@in...>]

My idea exactly, 

I also have been looking around and came up with zip/zilch in the 
open source projects...
mainly it it takes a sqlgenerator that is database dependant, takes care of
vendor types
and weird (read oracle 8) jdbc drivers/databases(in oracle 8 a "", empty
string, is a null ??? ).


-----Original Message-----
From: Joa...@tp... [mailto:Joa...@tp...]
Sent: Wednesday, May 08, 2002 10:49 AM
To: obj...@li...
Subject: [OJB-developers] Vendor neutral DDL scripting Tool


Hy,

you all probably know about the problem with different SQL dialects for 
different Databases. The Query part is actually quite ok, but DDLs just 
won't work on more than one Database, when any advanced feature is used 
(and sometimes "advanced features" are things like text that is longer 
than 255 characters). Most of this differences are just different names 
for a data type (example from db-setup.sql: LONGVARBINARY, BLOB, 
BLOB(32k), LONGBLOB, IMAGE). What I think would be great is a tool that 
takes ANSI SQL DDL and executes it on different database, after modifing 
the data types to fit the DB vendors idea of the name. While converting it 
could output warnings about changed behaviour (for example MySQL not 
handling spaces at the end of CLOBs correctly). I think writing such a 
tool once is less work than modfing db-setup.sql for each change and it 
would be easier to maintain ("Super-DB v36 does support the new 
HYPER_GROOVY_BLOB instead of the old PLAIN_BLOB"). Additionally it would 
be a great for us, as our product should run on quite some different 
databases ;-)

I would be willing to write such a tool, but I almost can't believe that 
there is no such thing out there ('though I didn't find it). Does anybody 
know if there are simillar tools somewhere? And if not does anyone know if 
there is a nice overview about the DDL of some databases? Especially the 
ANSI SQL Datatypes?

regards
Joachim Sauer

_______________________________________________________________

Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: ban...@so...
_______________________________________________
Objectbridge-developers mailing list
Obj...@li...
https://lists.sourceforge.net/lists/listinfo/objectbridge-developers