• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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