Automation compare deactivate summary report

Toad for IBM DB2
1

Hi,
is there a possibility to deactivate the generation of the summary report within an automation compare task?

We compare two databases with a lot of objects and the generation of the report takes about 1:22 h. The comparision itself takes less than 1 minute. We use Toad for DB2 6.5.

LOG-Output:
– 11.12.2018 13:54:43: compare_F_XX.log: Object compare is running…
– 11.12.2018 13:55:11: compare_F_XX.log: Generating synchronization script…
– 11.12.2018 13:55:15: compare_F_XX.log: Writing synchronization script to file…
– 11.12.2018 13:55:15: compare_F_XX.log: Object Compare synchronization script generated, click compare_F_XX_SyncScript.sql to view file.
– 11.12.2018 13:55:15: compare_F_XX.log: Generating compare report…
– 11.12.2018 15:17:52: compare_F_XX.log: Object Compare report generated, click compare_F_XX_CompareSummary.pdf to view file.

I’ll try to upload one screen shot from the compare task properties.
Sincerely,
Daniel
compare_properties

2

Daniel,
You have to specify either a 'Summary Report file" or a "Sync script file" or both.
It seems that if you specify only a "Sync script file" Toad is throwing an error - but the compare works. I will open a ticket to fix that in a future release.

Also important to note is that in our v7.0 version of Toad DB2 (currently in beta - but will GA in the first quarter of 2019) we revamped our pdf report generation to greatly reduce the time it takes to generate pdf reports. You might want to test that out in our existing beta. You can download that beta at the top of this topic:
https://forums.toadworld.com/t/toad-for-db2-beta/41276

3

Hi Jeff,
thanks for your reply.

We use your workaround and will wait for the fix in the future release.
Furthermore we will have a look at the Beta Version.

Kind regards,
Daniel