toad migration from 2.1 to 2.5.1

Toad Data Point & Toad Intelligence Central
1

hi,

I have two server running toad and i have just upgraded one server and when i launched toad it asked me to migrate. i selected ok and it all worked, no problems.

I then tried to upgrade the second server and when it asks me to migrate i get the following error.

System.Runtime.Serialization.SerializationException
Attempting to Deserialize an empty stream
Stack Trace:
at System.Runtime.Serialization.Formatters.Soap.SoapFormatter.Deserialize(Stream serializationStream, HeaderHandler handler)
at System.Runtime.Serialization.Formatters.Soap.SoapFormatter.Deserialize(Stream serializationStream)
at Quest.Toad.Settings.ToadSettings.LoadSettings(String fileName)
at Quest.Toad.Settings.ToadSettings.LoadSettings()
at Quest.Toad.Settings.ToadSettings.UnloadSettings()
at Quest.Toad.Util.Migration.MigrateSettingsDirectory(MigrationCandidate candidate)
at Quest.Toad.Util.Migration.MigrateSettings()
at Quest.Toad.Gui.MainForm.runFirstEverExecution()
at Quest.Toad.Gui.MainForm.MainForm_Shown(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnShown(EventArgs e)
at System.Windows.Forms.Form.CallShownEvent()
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

any help much appreciated.

thanks

2

That fastest way to rectify this is to rename the settings directory and let the application generate new default files.

To do this, go to the path below or your equivalent. If you are on Vista or Win 7 the path will be a little different. You will also have to change for your profile name.

C:\Documents and Settings%YOurProfile%\Application Data\Quest Software\Toad for Data Analysts 2.5.1

Once there, rename the directory, restart Toad for Data Analysts and do not select the migrate option. After that, you could copy over the connections.xml file, as that is the main file you will miss migrating the most.

Let me know how this goes.

Debbie

3

Hi Debbie,

Thanks for that. This did not seem to work eiter. In the end i had to load toad and import the connextions xml file using connection manager. Will this make a difference? it seems to be working so far

One other minor issue/more annoying is that all users access the application and when toad loads it load the navigation pane and the query builder except for two users!! any way of the query builder opening with the navigation pabe as it does with all the otehr users.?

Thanks

phill