Schema compare times out

edited December 12, 2013 5:42AM in Schema Compare for Oracle
Hello,

I can open test connections to my databases but the comparison times out during the "Reading dependency information" phase ("Initializing database connection" lasts a minute or so, and then a "Network error" appears).

I suspect this may be due to long time needed to read ALL_OBJECTS table in the database and I would like do increase timeout.

How can I increase the timeout?

Thanks for any help.
Grzegorz

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi,

    Thank you for your forum post.

    Can you please try adding the ConnectionTimeout = <value in seconds> to the connection string commands in the Server name box, for example:
    ServerName\InstanceName;ConnectionTimeout=600
    
    where the value 600 = 600 seconds
    

    I see that you have also created Support Ticket #9534, any further problems please update this support call.
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.