File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Comparing database schemas Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Comparing database schemas" Watch "Comparing database schemas" New topic

Comparing database schemas

J Rosetto

Joined: Jun 03, 2008
Posts: 21

I have two Oracle instances which need to be identical. One is built from an old base schema and a number of patch scripts. The other one is built from a new schema file which should be the same as the fully patched database.

Is there any way to easily compare two databases using something like db-unit? I will need to compare not only columns and data, but also stored procedures etc.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

The link in my signature (DbTamer) is a free tool designed to perform tasks like this.
Probably the easiest is to use it to extract both to a DDL and then compare the output files.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Ah stored procedures - not so much
I agree. Here's the link:
subject: Comparing database schemas