Validating table existence across environments

Frosty the Coder

Legendary Poster
Our CNCs created a new DV3 environment and refreshed the data in it from production.

We have tables that aren't in production, are in DV, and need to be in DV3.
We'd like to identify and generate those tables which are in DV, but not DV3.

Is there anything in E9 that provides this sort of comparison?

Please and Thanks
 
You can run R9698711 (in summary mode) over both environments and export the output to CSV. Then use Excel to compare the outputs.

A quicker way will be to use system database views to get the list of tables and compare them (using SQL or Excel).

Hope this helps.
 
Thanks very much.
I will look into the UBE you've suggested.
 
Back
Top