• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Comparing database schemas

 
J Rosetto
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ah stored procedures - not so much
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic