Existence of multi-DB schema synchronizator

From: Gustavo <grandich_at_ardison.com>
Date: 23 Jul 2002 15:17:03 -0700
Message-ID: <4f10fcb1.0207231417.1e92297b_at_posting.google.com>



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").

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 Jul 24 2002 - 00:17:03 CEST

Original text of this message