• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

Know of a tool for comparing database changes?

Dear Experts,

I need to compare an old version of a database to a new version.  Specifically, I need to find out:

What are the new tables?
What tables are gone?
Within each table:
    What are the new fields?
    What fields are gone?
    What are the new keys?
    What keys are gone?
    etc.

Does anyone know of a tool that will do this?  Or some freeware/shareware, preferably in Java?  My db happens to be MS SQL.

Thanks!
BrianMc1958

   
0
BrianMc1958
Asked:
BrianMc1958
  • 2
1 Solution
 
BrianMc1958Author Commented:
btw, I'm only looking for changes to the structure of the tables.  I don't care about the data itself, or any of the other db-related things like users and security...
0
 
shinobunCommented:
I don't know of a tools that specifically does that, but with a tool that can export the schema as scripts, you can compare the exported scripts to find out.

I know Aqua Data Studio has an export schema functionality:

http://www.aquafold.com/
0
 
shinobunCommented:
Another is Druid:

http://druid.sourceforge.net/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now