Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrating DDL from one db product to another using JDeveloper

623917Apr 1 2011 — edited Apr 1 2011

I design my database schema structure using JDeveloper. I maintain a database diagram using offline schema, and create SQL from it ("Generate SQL from Database Object").

The offline schema emulates Oracle 11g. The real physical database is also Oracle 11g. This setup works fine.

Now I want to use the same schema in a in-memory database for some automatic testing. Candidates are for example Derby or HSQLB.

JDeveloper seems to support Derby, and "standard SQL" offline databases. But can I use JDeveloper to convert the tables and SQL from Oracle dialect to Derby or standard SQL dialect?

If I try to use "copy database objects to a project" I only get "You have chosen a source type of Oracle 11g. The target offline database can only hold database objects compatible with Derby database..."

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2011

Added on Apr 1 2011

#application-development-in-java, #jdeveloper-and-adf

1 comment

182 views