Archives of the TeradataForum

Message Posted: Sun, 16 Dec 2007 @ 09:09:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Suresh,

If the tables reside in two different databases but on similar server then you could use the following DBC tables/views.

     DBC.Tables (Table information)
     DBC.Columns (column names, column ordering, column type, etc)
     DBC.Indices (Index type)
     DBC.IndexConstraints (PPI and other constraints)

If you were to compare data across two different servers, then you will have to export DBC information from one server and load into a temporary database of other server.

This way you will be able to compare the information from DBC of current system with DBC information imported from other RDBMS.

I believe there may be ready made tools available in market but I have not used them.

HTH!

Thanks,

Vinay Bagare

	<Prev	Next>		<<First	<Prev	Next>	Last>>