'm trying to use the Compare Schema and Sync tool in Toad for Sybase 1.1 and I get the following exception error when trying to sync one table:
System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at Quest.Schema.Sybase.ActionGen.ActionGenerationHelper.Column.GetBaseTypeName(IPropertyHolder column)
at Quest.Schema.Sybase.ActionGen.ActionGenerationHelper.Column.GetRealTypeName(IPropertyHolder column)
at Quest.Schema.Sybase.Sync.Workers.Sync.SyncWorkerTable.AddConvertTruncateMessages(SyncContext context, SinglePairModelObject`3 column)
at Quest.Schema.Sybase.Sync.Workers.Sync.SyncWorkerTable.<GenerateActionsAlter>d__2d.MoveNext()
at Quest.Schema.Sybase.Sync.Workers.Sync.SyncManager.<generateActionsAlter>d__6.MoveNext()
at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)
at Quest.Schema.Sybase.Sync.SyncLegacy.Sync.GenerateScript(ICallBack callBack)
at Quest.Schema.Sybase.Sync.SyncLegacy.Sync.Process(SelectedObjectCollection selectedObjects, ICallBack callback)
at Quest.Schema.Sybase.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)
Steps to replicate the issue:
1. Run the Schema Compare using default selections comparing two tables.
2. Filter selected objects so that source and target differences are shown.
3. Select the table and run the Synchronization Wizard.
4. Use the default selections and error should generate after screen showing what objects have been selected.
WORKAROUND:
None.
STATUS:
Waiting for fix to be released in a future version of Toad for Sybase.
