如何保存我的 Oracle Toad 连接以移动到新 PC？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10875330/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How can I save my Oracle Toad connections to move to a new PC?
提问by gimpy
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.
我想转移到一台新 PC 并随身携带我的 Toad 连接，因为我有一些并且不想全部重新键入。
回答by Kobus Smit
Copy the %APPDATA%\Dell\Toad for Oracle\VERSION\User Filesfolder to your new PC.
将%APPDATA%\Dell\Toad for Oracle\ VERSION\User Files 文件夹复制到您的新 PC。
Ie.
IE。
C:\Users\USERNAME\AppData\Roaming\Dell\Toad for Oracle\VERSION\User Files
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
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".
注意：在旧版本的 Toad“Dell”中，上面的路径曾经是“Quest Software”。
回答by Sebas
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.
您必须保存各自的 oracle 安装的 tnsnames.ora 文件。另外，我相信 TOAD 使用 TNS_ADMIN 环境变量来定位它正在使用的 TNS_NAMES.ORA。
回答by Constantin C
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).
然后使用“导入”按钮（带有指向 UP 的蓝色箭头 - 位于弹出屏幕的顶部）。
回答by user10515068
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.
Toad 12.6 - 64 位处理文件夹对我不起作用。Toad 有新的选项-菜单实用程序-> 复制用户设置。这有效并导入了用户 ID 和密码。
回答by theoptips
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:
还要注意的另一件事是，在 Evan 指定的新计算机文件夹目标中（通常它在 ADMIN 文件夹中，您可以搜索 ora 格式，很少有另一种格式的文件）。如果安装 Toad 后，已经存在一个 tnsname.ora 文件，您必须做一些工作：
- 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.
- 复制和粘贴
- 如果遇到问题，请退出文件夹，右键单击并选择管理视图（尤其是对于 Windows 7 和 Vista）
- 允许您编辑文件
- 如果不允许粘贴，只需剪切并移动现有的 tnsname.ora 文件并将其“剪切”出文件夹
- 然后将正确的移入
- 通常，您现在可以编辑 ADMIN 文件夹外的 tnsname.ora 文件，随意打开并粘贴所有 TNS 名称。
