What is the best way to save your current settings before an upgrade and import them one the upgrade is complete?
Starting with Toad 10, the first time you run the new installation of Toad, it will automatically detect previous installations and prompt you to copy your user files from one of those previous installation to your new installation. If your previous installation is not listed in the drop-down box (ex. if you have backed up your user files to a network folder or reinstalled your machine), it also provides the ability to select from an alternate location.
Please note that for compatibility reasons, we only support copying user files from up to two versions back.
-John
Ok, so we have the scenario where most of our users are on 9.x. We are getting PC upgrades, so they will pre-install version 10. Can you do it post installation?
If so what files or directories should I have the users copy to their network drive?
Thanks!
If they have pre-installed Toad 10, but not run it yet, you will automatically be prompted to copy your user files from a previous version. Since it’s a new machine install, you won’t see any versions listed in the drop-down box, but you can click on the ellipsis button next to the drop-down to select a folder from which to copy your previous user files. If your current version of Toad is 9.7 or later, these files should be located in:
Windows XP and earlier:
c:\Documents and Settings\Application Data\Quest Software\Toad for Oracle\9.7
Windows Vista and later:
c:\Users\AppData\Roaming\QuestSoftware\Toad for Oracle\9.7
You can copy this folder to anywhere on the network, or on a USB thumb drive. Then when the Initial Setup Wizard pops up, use the ellipsis button to select this folder. If your network admins have already run and configured Toad for Oracle, simply rename the following folder:
Windows XP and earlier:
c:\Documents and Settings\Application Data\Quest Software\Toad for Oracle\
Windows Vista and later:
c:\Users\AppData\Roaming\QuestSoftware\Toad for Oracle\
… and Toad will consider itself a new install, recreate the folder, and prompt you to copy over your previous user files.
-John
This looks like a nice candidate for AskToad
Morning all,
This looks like a nice candidate for AskToad
Done.
or
to_saveimport_toad_settings
or
Select FAQ on the left.
Select Installation on the right.
It's the last link in the installation section.
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Awesome, Norm! Thanks!
Rich -- [TeamT]
Disclaimer: "it's full of stars!" -- LOL
Morning all,
This looks like a nice candidate for AskToad
Done.
Hi Rich,
Awesome, Norm! Thanks!
Welcome.
Disclaimer: "it's full of stars!" -- LOL
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Hi;
How identify a SQL request which does not work and generate an error (Exception) with TOAD 9.7 (database oracle 10g) ?
Regards;
How are you running your SQL request? The editor should ID the offending SQL
pretty clearly.
Hi;
How identify a SQL request which does not work and generate an error (Exception)
with TOAD 9.7 (database oracle 10g) ?
Regards;
Wow, that’s a huge can of worms there.
I’d have to know more about your web technology, but I’d start with
looking at the web server error log.
Have you taken the same sql and ran it via Toad? You can see what your program
is doing using the Session Browser as it’s running. You can also trace
your session for a lot more information.
Hey Norm,
LOL!!! I’ve been side-tracked with other things this morning and just
now read the entry!!
I love it! 
-John
Morning John,
LOL!!! I've been side-tracked with other things this
morning and just now read the entry!!
Well, it was either that or John "the Subversion guy" (aka JTSG) and I
much preferred the one I used.
After all JTSG doesn't roll off the tongue the way that JIFOS does!
Cheers,
Norm. [TeamJoker]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk