score:1

I don't know of an automated way to do it, but it shouldn't be too hard. If it were my, I'd just submit my SQL Server or Oracle DDL to a test Derby database and start looking at the errors.

Then I'd start writing a short program in my favorite scripting language to process the DDL and change the parts that Derby is complaining about to the syntax that Derby requires.

score:1

Have a look at Liquibase.

You can define your tables (and other DB objects) in a DBMS independent XML definition. Liquibase will then take care of creating the approriate DBMS-specific DDL for you.

If you need to target different DBMS with the same definition source, this is definitely something you should look at.


More questions

More questions with similar tag