How can I save my Oracle Toad connections to move to a new PC?

B

6

14

I want to move to a new PC and take my Toad connections with me because I have a few and don't want to retype them all.

Bet answered 4/6, 2012 at 1:16 Comment(1)

Please have a look at asktoad.com/DWiki/doku.php/faq/answers/general – Diondione 4/6, 2012 at 1:20

Q

17

Copy the %APPDATA%\Dell\Toad for Oracle\VERSION\User Files folder to your new PC.

Ie.

C:\Users\USERNAME\AppData\Roaming\Dell\Toad for Oracle\VERSION\User Files

C:\Documents and Settings\USERNAME\Application Data\Dell\Toad for Oracle\VERSION\User Files

Beware: In older versions of Toad "Dell" in the path above used to be "Quest Software".

Quark answered 30/1, 2013 at 8:39 Comment(2)

C:\Users\USERNAME\AppData can be changed with %APPDATA% – Alvinalvina 26/7, 2016 at 21:39

Also note the location of your Oracle home is stored in the Connections.ini file and you will want to ensure that, that location is the same on the new machine. – Meadowsweet 9/9, 2016 at 20:39

V

3

Go to %APPDATA%\Quest Software\Toad for Oracle\VERSION\User Files\ folder. Copy the following files: CONNECTIONACTIONS.INI and Connections.xml, to the same folder in the new PC.

Ie. C:\Users\USERNAME\AppData\Roaming\Quest Software\Toad for Oracle\13.2 Trial\User Files

Vilmavim answered 19/10, 2020 at 17:40 Comment(0)

P

2

You have to save your tnsnames.ora files of your respective oracle installations. Also, I believe TOAD uses the TNS_ADMIN environment variable to locate the TNS_NAMES.ORA it is using.

Prairial answered 4/6, 2012 at 1:19 Comment(1)

Agreed. For the Oracle 9 client this file is located (assuming a default install location) at C:\oracle\ora92\network\ADMIN. For later client versions the path might be slightly different. – Sole 4/6, 2012 at 13:7

M

2

On the Old machine: Menu> Session>New Connection

then Select all connections and Use the Export button(with a blue arrow pointing to Right Down - located at the top of the Pop up screen).

On the New machine: Menu> Session>New Connection

then Use the Import button(with a blue arrow pointing UP - located at the top of the Pop up screen).

Mapel answered 4/5, 2016 at 15:49 Comment(1)

This feature was introduced in Toad 11, and consequently you can only import these files with Toad 11 and later versions. – Mapel 4/5, 2016 at 15:51

F

2

Toad 12.6 - 64 bit coping the folders did not work for me. Toad had new option- menu utilities-> copy user settings. this worked and imported user ids and password.

Freely answered 16/10, 2018 at 19:42 Comment(0)

J

1

One more thing to note is that in your new computer folder destination as Evan specified (generally it is in the ADMIN folder, can you can search for ora format, pretty rare you have another file that format). If after installing Toad, there's already a tnsname.ora file exist, you have to do some work around:

copy and paste
if you run into troubles, back out of the folder, right click and select admin view (especially for windows 7 and vista)
that allows you to edit the file
if no pasting is allowed, just cut and move the existing tnsname.ora file and "cut" it out of the folder
then move the correct one in
generally you can now edit the tnsname.ora file outside of the ADMIN folder, feel free to open and then paste all the TNS Names.

Johm answered 25/6, 2012 at 5:16 Comment(0)

Recommended topics

Hot tags