Comparing COLLECT STATS/INDEXES/DDL between Databases

Database
Enthusiast

Comparing COLLECT STATS/INDEXES/DDL between Databases

Hi All,
We have two databases (DEV_RETAIL and TEST_RETAIL) used for different loads in the same Teradata Box. Different people are using these environments and before promoting the stuff from DEV_RETAIL to TEST_RETAIL to Production, i would like to make sure that all the below items are exactly matching between DEV and TEST.

1. DDL
2. Indexed (Primary,Secondary etc)
3. Statistics

Can we do all of the above by accessing DBC tables? Also, how can i achieve this, if the databases are across two Teradata machines?

Thanks
Venkat Rao
1 REPLY

Re: Comparing COLLECT STATS/INDEXES/DDL between Databases

Hi,

I'm new to this software and i've been using these tools earlier but i'm not sure whether TOAD and DBArtisan Compatible with Teradata ?

Thanks for your time and co-operation.

Regards