Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

4 Answers 4

up vote 1 down vote accepted

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.

share|improve this answer
I tested the tools from the answers and this one seems the best to use. – MacGyver Nov 4 '13 at 2:50

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).

share|improve this answer
Liquibase diff does not require the database to be under version control. – Andrew Hill May 27 '14 at 5:16

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

I've got some simple instructions to demonstrate it in my blog

share|improve this answer

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

share|improve this answer
Apparently, this requires the Oracle Change Management license, even though the tool is free to use. – MacGyver Jul 21 '13 at 3:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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