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.
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 only takes a minute to sign up.Sign up to join this community
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.