Re: Existence of multi-DB schema synchronizator

On Tue, 23 Jul 2002 18:17:03 -0400, Gustavo wrote:

> Hello,
>
> I need to know if there exists a tool that detects database schema
> (structure) differences between 2 databases and generates SQL scripts to
> alter 1 of them (the "target") according to the other (the "source").
>

We have a research project called Clio, that deals with precisely this problem. It is a joint project between University of Toronto and IBM Almaden. We have a number of papers on this subject (called "schema mapping"). You can find them, and also more info on the project at

http://www.cs.toronto.edu/db/clio/

> Requisites:
>
> - Multi-DB: ability to compare databases from Informix / SQL Server /
> Oracle servers. Example: compare an Informix schema with an Oracle
> schema.
>
> - Offline working: must be capable to work without being connected to
> the servers (using SQL scripts as input).
>
> - Check for differences in:
> - column names / types / nullability, etc. - Primary Key / Foreign Key
> / CHECK constraints (very important) - triggers - indexes
>
> - Must not be ERwin nor Adept SQL
Received on Wed Sep 25 2002 - 23:39:11 CDT