Saving setting to import to a new database name

Good Afternoon TOAD Team,

We are migrating our databases to the cloud and then updating database version. If I update TNSnames.ora to the new database using the old database name I can keep my settings, [Favorites, saved passwords, custom queries (in schema browser), custom filters ...]. Is there a way to save the setting for a database and import the settings for a new database name (the new database name happens to be identical to the old name)? As we upgrade databases this is also an issue. The capability would be nice to have.

Larry

Hi Larry,

In the User Files folder, there is a "Databases" folder. Under that you'll find folders named after tnsnames entries. If you copy one of those subfolders from the name of the old tnsnames entry to the new, I think that'll do it. At least most of it. If you notice something that doesn't cover, let us know.

-John

1 Like

Good Morning John,

Thank you! That worked great.

I was having trouble finding the directory, but a DOS command in c:\ found them as the last entries; then they were easy to navigate; don't know what my issue was:
C:>dir Databases.* /s

C:\Users\z-Larry-Wickliffe\AppData\Roaming\Quest Software\Toad for Oracle\13.2 beta\User Files\Databases

Larry

Ah, sorry, I should have mentioned - a sure way to find that folder is:

  1. go to Toad options -> General
  2. click on the "Open Folder" button on the right.
  3. An explorer window opens, browse down to User Files
  4. Close Toad and do whatever you need to do

Sounds like you found it, but for those with multiple copies of Toad installed, this method will take you to the correct place.

1 Like

Good Morning John,

That is a great workaround, that would not be hard to automate, say the first time you connect to a database ask the user if they would like settings copied from an existing database, then do as they indicate, copy settings or create blank settings like TOAD does today.

Larry

Hi Larry,

That's true, this would be a simple addition, and I get that it would be helpful for you due to your heavy use of named filters and queries in the schema browser, but I wonder how many users would welcome the change, or just be annoyed by the prompt after a connection to a new database?

This might be a good one for idea pond....or...if someone else wants this, just speak up here

-John