Configure timeout settings on command line interface.
Currently there is a 60 second timeout on all script executions for SCO deployment. I have run into situations where indexes on large data sets or table rebuilds on large tables exceeds that time frame resulting in SCO prematurely exiting the script deployment. The recommendation was to invest in better hardware. Unfortunately, better hardware cannot solve this problem where large data sets are in play. Having the ability to adjust the timeout default could help avoid such situations.
See for reference issue: http://redgatesupport.red-gate.com/requests/16832
This is now in the latest release available via download or check for updates
-
AdminRichard Mitchell (Admin, Redgate) commented
The full release notes for all releases are available from http://documentation.red-gate.com/display/SCO3/Schema+Compare+for+Oracle+3.0+release+notes
-
AdminRichard Mitchell (Admin, Redgate) commented
It has been in all releases since May 2014 so updating to the latest 3.0.10.820 should fix it just fine.
-
James Allman commented
By latest update do you mean version 3.0.10.820?
-
AdminRichard Mitchell (Admin, Redgate) commented
I've removed the timeout from the latest release, currently available as a pre-release from the Red Gate Support forums. http://www.red-gate.com/MessageBoard/viewtopic.php?t=20629