Migrating process from 2.7 to 3.1.0638 was running and an error message was displayed:
System.IO.IOException
The file 'C:\Documents and Settings\kg0ohd\Application Data\Quest Software\Toad for Data Analysts 3.1\SQLFormatter\Defaults.xml' already exists.
Stack Trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite)
at Quest.Toad.Util.Migration.DoStep()
at Quest.Toad.Animation.WinProgressDialog.Start(ProgressOperationCallback callback)
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()
Please try:
1. Launching Toad again and cancel when prompt to migrate from 2.7.
2. Then exit Toad and you can bring over the connection inform from Toad 2.7 to 3.1 by copying the file connection.xml from C:\Documents and Settings\username\Application Data\Quest Software\Toad for Data Analysts 2.7 to 3.1.
If you are on Windows 7, it will be C:\user\username\AppData\Quest Software\Toad for Data Analysts 2.7