Sign up ×
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.

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 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

2 Answers 2

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

You can adjust this in the Connection Properties => Advanced... => Connect Timeout. The default is 15 sec, increase it to a higher number.

share|improve this answer
Can you provide a little more information and possibly a screen shot or two? – Erik Sep 22 at 15:19

Your Answer


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.