Re: Schema comparison

The DMS Reengineering Toolkit is generalized compiler technology for implementing customized analysis/transformations of large scale software system sources.
DMS parses, build compiler-like data structures, and then carries out custom analysis and transformation steps, finally prettyprinting the updated compiler data structures back to source text, to achieve a desired goal.
DMS knows how to process C, C++, COBOL, Java, ANSI and Oracle SQL, ... See http://www.semdesigns.com/Products/DMS/DMSToolkit.html.

A DMS-derivative tool, the CloneDR, finds duplicate code across many source files. It would be very good at finding the "duplicate" part of your new model,
showing what hasn't changed, and what had changed. See http://www.semdesigns.com/Products/Clone/index.html

One could use this information as the input to custom transformations to build a schema data translator.

--
Ira D. Baxter, Ph.D.,CTO           email: idbaxter_at_semdesigns.com
Semantic Designs, Inc.              web: http://www.semdesigns.com
12636 Research Blvd. C-214    voice: (512) 250-1018 x140
Austin, TX 78759-2200             fax: (512) 250-1191


"Brian Dick" <bdick_at_home.com> wrote in message
news:MBVk6.5392$PR.38664_at_news1.wwck1.ri.home.com...


> We are working on a new version of our database and need a tool that can


> compare the new schema with the current production schema. I would like to

> use the output from the tool to write a script to migrate the production

> schema to the new schema.

>

> Anyone using such a tool?

>

> Later,

> BEDick

>

>