Toad World® Forums

Importing connection and passwords from 12.8 to 14.0

Hi!

We have a bunch of users migrating from Toad for Oracle ver. 12.8 to ver. 14.0.

Ver 12.8 gives you the option to export your connections directly as a .txt file, but doesn't say anything about exporting passwords included with those connections.

Ver 14.0 is able to import those connections, but requires a "Master password" for importing the passwords, as part of the encryption process. Since there's no way to set a master password for exporting passwords, when doing it from 12.8, users are not able to import passwords from the old version.

Exporting connections from 14.0 has this option to set a master password for exporting passwords along with the connections.

Is it not possible to export passwords from different connections in 12.8? If that's the case, is there a workaround to this, like manually replacing files in the AppData folder?
We have users with over up to 50 or above connections and entering passwords again to each one of those connections is a lot of extra work on a busy period.

Sincerely,
Mark

Normally, when upgrading, you can just install the new version (w/o uninstalling old version first), and your connections and other settings are imported. But we've improved our encryption algorithm a few times over the years, and passwords are lost on such a big version jump.

But here's something you can do, if you can get a copy of in in-between version, like 13.0 (I just tested this and it worked for me).

If you've already installed 14.0, then uninstall it before beginning this process.

  1. Leave 12.8 installed.
  2. Install version 13.0 and run it.
  3. The User Files folder for 13.0 (which should be something like: C:\Users\your_windows_user_name\AppData\Roaming\Quest Software\Toad for Oracle\13.3\User Files, will now contain a file called Connections.XML.
  4. Install 14.0 and run it.
  5. Copy Connections.XML from the 13.3 User Files folder to the 14.0 User files folder, which should be something like C:\Users\your_windows_user_name\AppData\Roaming\Quest Software\Toad for Oracle\14.0\User Files

After that, it's perfectly fine to leave all versions installed. They will each keep their own copy of settings moving forward.

Thank you, seems like that has done the trick.

On a bit of a different note; is there a reason why 14.0 has trouble closing? Even if we just open Toad and close it as soon it loads up, it seems to hang for an X amount of time or forever(?). Sometimes it closes after a couple of seconds, sometimes after a few minutes and sometimes it hasn't closed even after 30 minutes. When we press the X to close it, the whole program just hangs and stops being responsive, as if it's trying to close, but not entirely succeeding. The only way to close it from then is to kill the task in Task Manager.

Version 12.8 and 13.3 don't have this issue and close instantly.

Someone also reported that closing a session does not get rid of the query edit window they had open and also cannot be closed manually, making the whole program hang again (waited roughly 15 minutes) and must be forcefully closed through Task Manager. This also doesn't happen every time.

Does it help if you go to Options -> Online, and disable "Toad Improvement Program"?

When that's enabled, Toad collects anonymous usage data (nothing specific about your schemas or data, just how you use Toad). But if there is a problem sending that data, it could cause a delay on closing.

If that's not it, you could take things a bit further by editing Toad.ini (do this while Toad is NOT running) and adding this under the [SETTINGS] section:

InternetAccess=0

Toad.ini is typically located at C:\Users\your_windows_user_name\AppData\Roaming\Quest Software\Toad for Oracle\14.0\User Files\Toad.ini

And if you want to take things another step further, you could also install the 14.1 beta. There have been numerous bug fixes since 14.0 in the beta (and not much in the way of new features).

You can get that here: Toad for Oracle 14.1 Beta

The nice thing about beta is if you find a bug, you can report it here. If we can reproduce it, we can get bug fixes to you quickly. New beta versions typically come out on Mondays.

Hi, sorry for the late reply.

I couldn't find the Options menu. I did find TOAD options under "View", but that just hanged the program and wouldn't respond (waited roughly 10 minutes).

Changing Toad.ini and adding InternetAccess=0 to [SETTINGS] section fixed the issue though. TOAD also used to open for about a minute and now it opens in a few seconds.

Thanks for the help!

1 Like