db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel López <D.Lo...@uib.es>
Subject Re: Use DdlUtils to maintain a ddl than can be shared between Oracle and Derby
Date Wed, 10 Sep 2008 08:11:06 GMT

With DDLUtils, you can also export the database schema to an XML 
database independent format, so I guess that if not direcly, you could 
at least export the schema from oracle to the XML format and then from 
the XML to Derby.
There probably is a way of doing the same process programatically, but I 
just use DDLUtils through the Ant tasks, so I don't have experience with 
that. But just so you know there is at least one way of doing it.


Erik Drolshammer escribió:
> Hi!
> I want to use Derby as an in-mem substitute for Oracle for automatic 
> testing purposes.
> I have successfully exported the schema from an existing Oracle schema 
> (without data) to a ddl-file, but when I try to create tables etc. in 
> Derby I run into problems.
> Does DdlUtils support some sort of automatic conversion between 
> "Oracle-sql" and "Derby-sql"?
> Or must I manually convert e.g. Oracle's "varchar2" to Derby's "varchar?
> This is the setup I currently use:
> //Create ddl from Oracle database
> Oracle10Platform oracle10Platform = new Oracle10Platform();
> oracle10Platform.setDataSource(dataSource);
> Database database = oracle10Platform.readModelFromDatabase(name, 
> catalog, schema, tableTypes);
> //Create Derby tables from Oracle ddl source
> oracle10Platform.createTables(conn, database, 
> dropTablesFirst,continueOnError);

View raw message