When trying to run schema compare on two servers, choosing all tables gives the following error:
System.ApplicationException
Problem with load ExtendedProperties
Stack Trace:
at Quest.Schema.Common.ModelLoad.ModelLoader`6.Run(ICallBack callback)
at Quest.Schema.Common.ModelLoad.ModelLoadManager`7.Loader.LoadModel(ICallBack callback)
at Quest.Schema.Common.ModelLoad.ModelLoadManager`7.CreateInstance(ICallBack callback, SchemaSnapshot snapshot, OptionsStorage options)
at Quest.Schema.MSSQL.ModelLoad.ModelLoadServiceMSSQL.Create(ICallBack callback, SchemaSnapshot snapshot, OptionsStorage options)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.LoadModelFromSnapshot(ICallBack callback, SourceLoader source)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.Source
The compare starts but never finishes. If just a few tables are chosen, it does not error out. Server compare seems to work without issue. Ignore extended properties is checked and it still errors out.
WORKAROUND:
None
STATUS:
Issue fixed in version 5.8. The latest version of Toad for SQL Server can be downloaded here.
