Is it possible to export saved passwords from Toad_问答_开发者

I'm looking for a way to export saved usernames/passwords from Toad for Oracle (9.5.0.31). It doesn't have to be in a usable format for importing - even a plaintext format would be fine.

I believe the passwords are stored encrypted in CONNECTIONPWDS.INI, but from what I've read, that file doesn't transfer from one machine to another. There doesn't seem to be anything in the Quest site or the Yahoo groups about this, other than "That开发者_StackOverflow's a very good suggestion...".

Has anyone had any luck accomplishing this? Or am I stuck with having to dig up the passwords for each of my accounts?

Thanks

I did not find any way to export ALL connections but I can export one by one using the information from following link. Trick is to

Create db link.
Choose one of the existing connections
Set user/pass to current
Show sql

In the opened window, you can see your stored password. I successfully retrieved my stored password using this way.

i've always used the copy user files from utilities .. copy user files and then I do an export. when I reinstall on a new machine/laptop after lease rollout, I then import my user settings using the zip file created and everything is populated. passwords, settings, connection information etc.

In Toad 12.1.X and above , there is option to import and export in the connections screen . If you have already checked "Save Check Box" option . Simply export into a text file and the same text file can be imported to your new toad . It works.

I just used the copy user files from utilities method in Toad and it worked like a charm.

Open the Toad for Oracle version you want to export the user settings from and go to the menu and click on Utilities then Copy User Settings….

A Copy User Settings dialog box is displayed, you select the second radio button then Export and type in or Browse for the local or network path you want to save the generated zip file too.

Then open up the updated Toad for Oracle version and import the same zip file that was generated.

This method is especially useful when you get a new computer and need to install Toad for Oracle again. With this method everything is populated; Passwords, settings, Connection information etc.

As the answer from user8133620 and the answer from Saif have mentioned:

"Utilities" > "Copy User Settings..."
Select "Copy user file from a previous installation"
Click "Browse..."

Tricky part! You must browse to your user data area. If you browse to the wrong place, Toad will warn you that the directory you picked doesn't contain a User Files directory. And if you browse to the Toad installation directory in Program Files (x86), you will find a User File directory; Toad will accept this as valid, but will not actually import your settings.

This is the one you want:

C:\Users\%USERNAME%\AppData\Roaming\Quest Software\Toad for Oracle\11.0

_{You'll have to replace part of the path with your own version number (I was upgrading from version 11.0).

If you have trouble finding that location, try searching for either of the following files on your hard drive:}

CONNECTIONS.INI
CONNECTIONPWDS.INI

Another tricky part! As mentioned in the answer from Sagar Gangula, you need to have the "Save passwords" box checked. If you do not have this box checked, connections and user names will be imported, but passwords will not be. If you realize your mistake, and check the box and try to import again, existing connections will NOT be updated/overwritten. You must:

Remove all connections
(select all rows using Ctrl + click with the mouse or by using CTRL + A, then tap Delete)
Make sure the "Save passwords" box is checked
Import all connections again

Using the "Copy User Settings..." feature (Toad 12.1.X and above) will let you do the following in a single step:

Import/Export all all your preferences (from the User Files directory or a zip archive)
Import/Export all your existing connections (including username & passwords)
Transfer all of this from one computer to another (including username & passwords!)

Tested and confirmed in Toad 13.0.0.80

Is it possible to export saved passwords from Toad

The Talkingbyte.com service as mentioned above does work, but it's not free (~$10). I tested it with a demo server and it worked. It gave me enough of a [free] hint to confirm that it did accurately decrypt the Toad config-file.

Now, I'm not sure I would trust it with my production database passwords, but at least it's an option that works and a last resort should you desperately need it!

Well, this one got me the Tumbleweed badge (no comments or answers for a week)...I guess there's either no Toad experts out there, or no way to do it.

I never could find an answer, so I'm going to assume there's no way to do it, and I'll dig up all of my passwords.

Copy CONNECTIONPWDS.INI over you newly installed Toad. Make sure Toad is closed otherwise it will resort back to no connections.

Try to create a dblink for this connection and if you have saved this passw you can see this when you click the option show script.

The DB Link solution mentioned above works but I have some 30+ credentials. For me the following worked: Export the connections (assuming passwords are saved) and before importing, I updated the value for 'SavePassword' to true and it worked for me.

<SavePassword>True</SavePassword>

Have you tried to copy the file. I did the same thing to my new system and restart toad, all saved connection from my previous system got loaded.

I haven't tried this recently but I have certainly successfully transferred the encrypted passwords file from one installation to another (on configuring a new work PC) so if it doesn't work on current versions of TOAD they must have spotted and dealt with that loophole... a pity, because it was so convenient!

There was no option to extract the passwords back then and doesn't seem to be one now.

Can't you just create a query that returns data of the current connection you are trying to get the password for and then export that to Excel. Once the query is in Excel then look at the connection string. Should be able to see the sever, user name and password.