OT: DB Schema content comparison tools

[Paolo F Cantoni]

In another topic (DB Code Generation), Omian is asking about differential schema code generation.

I have the need to do content comparisons of the same table in different Schemas.  Does anyone know of a tool that can do that?

TIA,
Paolo

[Graham_Moir]

If your DBMS is Microsoft SQLServer, then yes - excellent products from Red-Gate.  See

http://www.red-gate.com/products/sql_compare/index.htm

and for data comparison

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

[Paolo F Cantoni]

If your DBMS is Microsoft SQLServer, then yes - excellent products from Red-Gate.  See

http://www.red-gate.com/products/sql_compare/index.htm

and for data comparison

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

Thanks Graham,

Our target is Oracle and the Quest TOAD tools have a Data Comparison function which will (by the looks of it) suit our immediate needs.

Paolo