• Post Reply Bookmark Topic Watch Topic
  • New Topic

Schema Comparison

 
Kirstin Schapitz
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I need to compare 2 mysql database schemas (tables, columns, used data types, keys, constraints) and would like to have the differences displayed.
Is there any free tool that can be run from the command line and which generates a report? Or is there a nice Java API which I can use? I know, there is some useful stuff in java.sql... where I would still need to do some programming to get what I need... I only want to do this if there is no other solution.
Thanks a lot in advance.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36015
424
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kirstin,
The "procedure" I use is to create a schema export in both databases and run the UNIX "diff" command against them.
 
Kirstin Schapitz
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, the diff solution is the easiest, but not the nicest because it doesnt tell you "contraint xyz is missing" for example...
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!