command line diff tool to compare db schemas?
687981Feb 26 2009 — edited Feb 26 2009We would like to have the following process where we have server A with an existing database with all it's tables(let's say it has db schema version 3). We want to do the following
1. export all the information regarding tables, columns, constraints, sequences to a file or something
2. blow away the database
3. recreate the database
4. have hibernate run with create and it will create all the tables and constraints and sequences
5. export all the information of this new schema(version 4) to another file or something
6. compare step 1 and step 5.
What tool can I use to do step 1, 5, and 6? This is all automated so I need some command line tools. How would I do this? I am quite new to oracle and new to diffing schemas as well.
thanks,
Dean