3
votes

I'm looking for an open source tool to generate DDL scripts. Many tools call these synchronization scripts. We essentially want to compare schema of different environments (ie: DEV to QA, QA to PROD) to manage object migrations/deployments a little easier. Do open source tools exist like this for Oracle?

4 Answers 4

1
vote

Disclaimer: I work for Red Gate.

Another tool that you may want to consider is Red Gate's Schema Compare for Oracle, which you can use to see a side-by-side view of schema differences and generate upgrade scripts. You can also carry out these tasks via the command line.

It's worth noting that Schema Compare for Oracle has been designed specifically for this task and we focus on making the tool fast, easy to use and accurate. But please don't just take my word for it: Schema Compare for Oracle reviews.

1
  • I tested the tools from the answers and this one seems the best to use. Commented Nov 4, 2013 at 2:50
5
votes

You might want to have a look at Liquibase - according to the Liquibase documentation, it can perform diffs (I'm not 100% sure whether this requires using Liquibase to version your schemas, though).

1
  • Liquibase diff does not require the database to be under version control. Commented May 27, 2014 at 5:16
4
votes

Try SchemaCrawler. It's open source and available on SourceForge.

I've got some simple instructions to demonstrate it in my blog https://gilesey.wordpress.com/2012/11/15/a-lightweight-schema-diff-or-dump-from-oracle/

3
votes

Not open source, but free to use is Oracle SQL Developer.

At least since version 3.2 Oracle SQL developer contains tools to export a DDL (Database Export) and also to compare databases (Database Diff).

Latest version can be downloaded here: Oracle SQL Developer

1
  • 1
    Apparently, this requires the Oracle Change Management license, even though the tool is free to use. Commented Jul 21, 2013 at 3:59

Not the answer you're looking for? Browse other questions tagged or ask your own question.