Comparing table columsn & indices twixt environments

  • Thread starter Frosty the Coder
  • Start date

Frosty the Coder

Legendary Poster
List,

(I'm pleased that I got to use the word "twixt". It's the highlight of what's been a dismal week.)

To the subject, is there a CNC-esque tool that compares tables, across environment, ensuring columns and inidices match?
 
There are reports that compare "JDE" specs vs "Database specs" to see that there is no mismatch in columns and indices. The index report can also go ahead and generate the indexes that are missing or do not match.

R9698711 and R9698713

Now this obviously does not compare between environments , but could run in both environments and compare the outputs.

If that seems a round about way , you best bet is to write a SQL query comparing F98711 between the two central objects datasources for table columns and F98712 and F98713 for table indices.
 
Ice,

That's exactly the info I need.

Thanks very much.

Frosty
 
Back
Top