Schema compare times out

gkaczor@e-point.plgkaczor@e-point.pl Posts: 2
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
· Share on Twitter

Comments

  • Eddie DEddie D Posts: 1,807 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
    · Share on Twitter
Sign In or Register to comment.