How can increase the SQL Command Timeout for SQLDataCompare?

paul.stanpaul.stan Posts: 2
edited July 21, 2016 10:40AM in SQL Data Compare 11
Hi everyone,

When we had tried to compare and sync 2 databases we have received the following error:

Error: Comparison of 'db1' and 'db2' failed: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Exit Code: 126.

It seems like there is a timeout issue.

Please let us know how we can increase the execution timeout for each SQL commands.
It seems like we do not need increase the connection timeout but we need to increase the command timeout.

Thank you,
Paul Stan
Tagged:

Comments

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    edited May 2, 2017 9:37AM
    Hi Paul

    As per the support call you raised with us, Call reference #69901, the connection timeout can be extended but the SQL Command Timeout cannot be extended with SQL Data Compare. I will check with the Development Team to see if it possible to extend the SQL Command timeout.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.