Schema Compare times out after a few minutes with the following error:
System.InvalidOperationException
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
Stack Trace:
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Quest.Shared.MSSQL.SQLConnOptions.GetOpenSqlConnection(ISQLConnOptions conn, Boolean defaultConnection)
at Quest.Shared.MSSQL.ScriptEngine.GetConnection()
at Quest.Shared.MSSQL.ScriptEngine.ExecuteDataAdapter(String script)
at Quest.Shared.MSSQL.Helper.SQLServerHelper.Info.GetServerVersion(IScriptEngine engine)
at Quest.Shared.MSSQL.Helper.SQLServerHelper.Info.GetServerVersion(ISQLConnOptions conn)
at Quest.Shared.MSSQL.SQLConnOptions.<.ctor>b__0()
at Quest.Shared.Memorizing.ThreadSafeObjectHolder`1.Initialize()
at Quest.Shared.Memorizing.ThreadSafeObjectHolder`1.get_Value()
at Quest.Shared.MSSQL.SQLConnOptions.get_ServerVersion()
at Quest.Shared.MSSQL.ScriptEngine.get_ServerVersion()
at Quest.Schema.MSSQL.Snapshot.Helper.CheckSupport(IScriptEngine engine, String databaseName, Version& serverVersion, Byte& compatibilityLevel)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.GetHeader(ScriptProcessor`1 processor, SnapshotHeaderUserProperties userHeader)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.Load(ICallBack callback)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.Run(ICallBack callback)
at Quest.Schema.MSSQL.Snapshot.SnapshotManager.CreateInstance(ICallBack callBack, ISQLConnOptions conn, SnapshotHeaderUser