是否可以从 Toad 导出保存的密码
我正在寻找一种从 Toad for Oracle (9.5.0.31) 导出保存的用户名/密码的方法。它不必采用可用于导入的格式 - 即使是纯文本格式也可以。
我相信密码以加密方式存储在 CONNECTIONPWDS.INI 中，但根据我的阅读，该文件不会从一台计算机传输到另一台计算机。除了“这是一个非常好的建议..."。
有没有人有幸完成这个任务？或者我是否不得不挖掘每个帐户的密码？
谢谢
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'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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（13）
我没有找到任何方法来导出所有连接，但我可以使用以下信息来一一导出 链接。技巧是
在打开的窗口中，您可以看到您存储的密码。我使用这种方式成功检索了我存储的密码。
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
In the opened window, you can see your stored password. I successfully retrieved my stored password using this way.
我一直使用实用程序中的复制用户文件..复制用户文件，然后进行导出。当我在租赁推出后在新机器/笔记本电脑上重新安装时，我会使用创建的 zip 文件导入我的用户设置，并填充所有内容。密码、设置、连接信息等。
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.
在 Toad 12.1.X 及更高版本中，连接屏幕中有导入和导出选项。如果您已经选中“保存复选框”选项。只需导出到文本文件，即可将相同的文本文件导入到您的新 toad 中。有用。
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.
我刚刚在 Toad 中使用了从
utilities方法复制用户文件，它的效果非常好。打开您想要从中导出用户设置的 Toad for Oracle 版本，转至菜单并单击
Utilities，然后单击Copy User Settings...。将显示复制用户设置对话框，选择第二个单选按钮，然后选择
导出，然后输入或浏览您想要保存生成的 zip 文件的本地或网络路径。然后打开更新的 Toad for Oracle 版本并导入生成的相同 zip 文件。
当您获得新计算机并需要再次安装 Toad for Oracle 时，此方法特别有用。通过这种方法，一切都被填充了；密码、设置、连接信息等。
I just used the copy user files from
utilitiesmethod 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
UtilitiesthenCopy User Settings….A Copy User Settings dialog box is displayed, you select the second radio button then
Exportand 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.
作为来自user8133620的回答和赛义夫的回答提到：
棘手的部分！您必须浏览到您的用户数据区域。如果您浏览到错误的位置，Toad 会警告您，您选择的目录不包含
User Files目录。如果您浏览到Program Files (x86)中的 Toad 安装目录，您将找到一个User File目录； Toad 会接受此设置为有效，但不会实际导入您的设置。这就是您想要的：
您必须用您自己的版本号替换部分路径（我是从版本
11.0)。如果您找不到该位置，请尝试在硬盘驱动器上搜索以下任一文件：
另一个棘手的部分！正如Sagar Gangula的回答中提到的，您需要选中“保存密码”框。如果未选中此框，将导入连接和用户名，但不会导入密码。如果您意识到自己的错误，并选中该框并尝试再次导入，则现有连接将不会被更新/覆盖。您必须：
（使用鼠标 Ctrl + 单击 或使用 CTRL + A 选择所有行，然后点击删除）
使用“复制用户设置...”功能（Toad 12.1.X 及更高版本）将让您只需一步即可执行以下操作：
用户文件目录或zip存档）在 Toad 13.0.0.80 中进行测试并确认
As the answer from user8133620 and the answer from Saif have mentioned:
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 Filesdirectory. And if you browse to the Toad installation directory inProgram Files (x86), you will find aUser Filedirectory; Toad will accept this as valid, but will not actually import your settings.This is the one you want:
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:
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:
(select all rows using Ctrl + click with the mouse or by using CTRL + A, then tap Delete)
Using the "Copy User Settings..." feature (Toad 12.1.X and above) will let you do the following in a single step:
User Filesdirectory or a zip archive)Tested and confirmed in Toad 13.0.0.80
上面提到的 Talkingbyte.com 服务确实可以使用，但它不是免费的（~10 美元）。我用演示服务器测试了它并且它有效。它给了我足够的[免费]提示来确认它确实准确地解密了 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.
将 CONNECTIONPWDS.INI 复制到新安装的 Toad 上。确保 Toad 已关闭，否则它将恢复为无连接。
Copy CONNECTIONPWDS.INI over you newly installed Toad. Make sure Toad is closed otherwise it will resort back to no connections.
尝试为此连接创建一个 dblink，如果您已保存此密码，则当您单击选项显示脚本时可以看到它。
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.
上面提到的 DB Link 解决方案有效，但我有 30 多个凭据。对我来说以下工作有效：
导出连接（假设已保存密码），在导入之前，我将“SavePassword”的值更新为 true，它对我有用。
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.
您是否尝试过复制该文件。我对我的新系统做了同样的事情并重新启动蟾蜍，所有从我以前的系统保存的连接都被加载。
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.
我最近没有尝试过，但我确实已经成功地将加密密码文件从一个安装转移到另一个安装（在配置新的工作电脑时），因此如果它在当前版本的 TOAD 上不起作用，他们一定已经发现并处理了这个问题漏洞……可惜了，因为实在是太方便了！
当时没有提取密码的选项，现在似乎也没有。
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.
您不能只创建一个查询来返回您尝试获取密码的当前连接的数据，然后将其导出到 Excel。在 Excel 中进行查询后，查看连接字符串。应该能够看到服务器、用户名和密码。
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.