File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Comparing database schemas Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Comparing database schemas" Watch "Comparing database schemas" New topic
Author

Comparing database schemas

J Rosetto
Greenhorn

Joined: Jun 03, 2008
Posts: 21
Hi,

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
Rancher

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
Rancher

Joined: Mar 06, 2001
Posts: 13459

Ah stored procedures - not so much
 
jQuery in Action, 2nd edition
 
subject: Comparing database schemas
 
Similar Threads
Configuring for testing
Date and Timestamp comparison
Shared mysql database
Refactoring databases: top-down vs bottom-up
Regarding a batch process design