Take the 2-minute tour ×
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
add comment

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
add comment

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 at 5:16
add comment

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/

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.