Toad World® Forums

Using the Toad DB2 Compare Tool to identify New Columns between Releases

When a new Release is received and added to a new environment we typically use Data Compare to identify Data Differences in the new database against the old database in another environment and the report is very helpful. is it possible to also automatically compare all column names to just get a report of new columns added? Object Compare does not seem to support this. We are on Toad 5.5. Thank you

Hi Anne,

The report in Object Compare is step 5 of 5. It shows the result of the comparison for every object you selected. And you can select objects in the upper panel to see detailed script differences for each object in the lower panel.

There’s also a button on the Object Compare toolbar that will create a text report of the results. You can customize the report in the Advanced Options of Object Compare.

Regards,

Adam