Re: Compare Tables Tool?

Hi Rowan,

You can try my Schema Comparison. It can compare tables' contents in different schemas and synchronize it. There are no LONG type support and SQL output. Download is at

http://protasov.simplenet.com/

  Andrew Protasov

Rowan McCammon wrote in message <3560CD5D.D8CB031_at_nospam.amp.com.au>...
>Hi All,
>
>Wondering if there is anything around which if given two tables of the
 exact
>same structure will produce a text file with the SQL statements to make
 them
>both the same.
>
>For example:
>
>Consider two schemas, BEFORE and AFTER, with the same structures. Both
 contain a
>table, TABLE1 of the following structure:
>
>TABLE1 ( ID, NAME )
>
>
>Example 1:
>
>BEFORE.TABLE1 ( ID, NAME ) = '1', 'Simon'
>AFTER.TABLE1 ( ID, NAME ) = '1', 'Simon Moy'
>
>DIF: UPDATE TABLE1 SET NAME = 'Simon Moy' WHERE ID = '1'
>
>-----
>Example 2:
>
>BEFORE.TABLE1 ( ID, NAME ) =
>AFTER.TABLE1 ( ID, NAME ) = '2', 'Leo Ng'
>
>DIF: INSERT INTO TABLE1 ( ID, NAME ) VALUES ( '2', 'Leo Ng' )
>
>-----
>Example 3:
>
>BEFORE.TABLE1 ( ID, NAME ) = '3', 'Russell Pegler'
>AFTER.TABLE1 ( ID, NAME ) =
>
>DIF: DELETE FROM TABLE1 WHERE ID = '3'
>
>---------
>
>To repeat above: Does Oracle supply a tool which can output the differences
>between the two schemas in SQL terms (see example below)?
>
>And if so...
>Can the tool be configured to automatically update the 'BEFORE' view after
>creation of the differences?
>Does the tool work with LONG fields?
>Can the tool examine all required tables and columns across two schemas
 based on
>some input definition?
>
>
>Any help on this appreciated.
>
>Regards,
>Rowan McCammon.
>
>--
>Remove the anti-spamming thingy from my email address to reply to me.
>
>The opinions expressed are my own and do not represent the opinions
>of my company.
Received on Wed May 20 1998 - 00:00:00 CEST