RedGate.Shared.SQL.ExecutionBlock

[aperregatturv]

I am having problem with ExecuteBlock of RedGate.Shared.SQL.ExecutionBlock. The problem is, i am trying to update a database using a snapshot but the database is close to 10GB size and its timing out. is there a way to add timeout so it doesn't timeout.

here' code i am trying
Work wrk = new Work();
wrk.BuildFromDifferences(diffs, Options.Default, true);
ExecutionBlock block = wrk.ExecutionBlock;
BlockExecutor b = new BlockExecutor();
if (NTAUTHENTICATE)
{ b.ExecuteBlock(block, DBSERVER, DBNAME, true, "", ""); }
else
{ b.ExecuteBlock(block, DBSERVER, DBNAME, false, USERID, PASSWORD); }
block.Dispose();

Thanks
Arun

[Chris Auckland]

Thanks for your post.

I believe you can add a connection timeout value (in seconds) to the connection string. i.e.

[aperregatturv]

Thank you. I will give it a try.