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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

locked by Paul White Jan 29 at 14:13

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

closed as off-topic by Paul White Jan 29 at 14:11

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White
If this question can be reworded to fit the rules in the help center, please edit the question.

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
    
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
    
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 https://gilesey.wordpress.com/2012/11/15/a-lightweight-schema-diff-or-dump-from-oracle/

share

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
1  
Apparently, this requires the Oracle Change Management license, even though the tool is free to use. – MacGyver Jul 21 '13 at 3:59

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