Toad World® Forums

Schema Compare Doesn't Generate Script

I tried to do a schema compare. Everything went great until I tried to generate the script. Then I got an exception:

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at Quest.Schema.MSSQL.Sync.Workers.Sync.SyncWorkerTable.SetProperty(SyncContext context, DDLPropActionEdit editor, IModelObject obj, PropertyInfo property, Object value)
at Quest.Schema.MSSQL.Sync.Workers.Sync.SyncWorker.InitializeCreateProperties(SyncContext context, IModelObject syncObject, DDLPropActionEdit editor)
at Quest.Schema.MSSQL.Sync.Workers.Sync.SyncWorkerTable.InitializeCreateProperties(SyncContext context, IModelObject syncObject, DDLPropActionEdit editor)
at Quest.Schema.MSSQL.Sync.Workers.Sync.SyncWorker.GenerateActionsCreate(SyncContext context, IModelObject syncObject)
at Quest.Schema.MSSQL.Sync.Workers.Sync.SyncWorkerTable.d__7.MoveNext()
at System.Collections.Generic.List1.InsertRange(Int32 index, IEnumerable1 collection)
at System.Collections.Generic.List1.AddRange(IEnumerable1 collection)
at Quest.Schema.MSSQL.Sync.Workers.Sync.SyncWorkerTable.GenerateActionsAlter(SyncContext context, ISyncPairObject pairObj)
at Quest.Schema.MSSQL.Sync.Workers.Sync.SyncManager.d__6.MoveNext()
at System.Collections.Generic.List1.InsertRange(Int32 index, IEnumerable1 collection)
at System.Collections.Generic.List1.AddRange(IEnumerable1 collection)
at Quest.Schema.MSSQL.Sync.SyncLegacy.Sync.GenerateScript(ICallBack callBack)
at Quest.Schema.MSSQL.Sync.SyncLegacy.Sync.Process(SelectedObjectCollection selectedObjects, ICallBack callback)
at Quest.Schema.MSSQL.Sync.SynchronizerModule.RunProcess(ICallBack callback, OnionContainer container, ActionManager manager)
at Quest.Schema.Common.OnionMechanism.Modules.ModuleWithActionManager.RunProcess(ICallBack callback, OnionContainer container)
at Quest.Schema.Common.OnionMechanism.Modules.Module.RunAsync(ICallBack callback, OnionContainer container, Object[] args)

Interesting. I get the same error in 6.0. It is supposed to be adding in a new trigger, but cannot generate the script. There is a varbinary(max) field on the table.

Hello J Fischer,

I created created change request so we can look into this. Will post back if more information is needed.

Thanks.