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
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