Hi,
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.
S!
D.
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);
|