Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to increase the timeout period for schema comparison.

I'm using Visual Studio 2012 to compare two SQL Server 2008 R2 databases on Windows Server 2008.

I believe this is something I need to set in the Windows registry but I can't find where.

share|improve this question

migrated from serverfault.com Jun 4 '13 at 13:15

This question came from our site for system and network administrators.

    
Is the database restored from different server and then you are doing the schema comparision ? – Kin Jun 4 '13 at 14:39

You have to increase the query timeout allowed on the connection. Unfortunately there is no user-interface-exposed way to do this. You have to search the Windows Registry for the key "QueryTimeoutSeconds" and increase the value. I increased mine from 60 to 360 and that made my schema compare timeouts disappear in Visual Studio 2012 and Visual Studio 2013.

share|improve this answer
1  
See here for more info: msdn.microsoft.com/en-us/library/… – Josh M. Jan 4 at 22:27

You can adjust this setting by opening your schema comparison and editing the connection which is timing out (source or target). Click the Advanced button and set the Connect Timeout property to a higher value than the default of 15.

share|improve this answer
1  
Can you provide a little more information and possibly a screen shot or two? – Erik Sep 22 '15 at 15:19
    
This setting didn't work for me. I believe there needs to be another settings for the query timeout (vs. connect timeout) not sure though... – Josh M. Nov 27 '15 at 16:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.