-
Title
Where does Toad for Oracle store code snippets? -
Description
Where does Toad for Oracle store code snippets?
-
Resolution
Version 9.7 and older:
The code snippet information is stored in User Files\Templates.xml file.
For Toad 9.6 and older the User Files folder is found in the Toad for Oracle installation directory, by default C:\Program Files\Quest Software\Toad for Oracle. For Toad 9.7, the User Files folder is found in the Toad for Oracle application data directory, by default C:\Documents and Settings\<personal folder>\Application Data\Quest Software\Toad for Oracle\9.7.
Version 10.x and newer:
The code snippet information is stored in User Files\CodeSnippets.dat file. For Toad 10 and newer, the User Files folder is found in the Toad for Oracle application data directory, by default C:\Documents and Settings\<personal folder>\Application Data\Quest Software\Toad for Oracle\<version>.
To migrate the saved information, carry over the file from the previous installation's User Files directory to the appropriate location for the new installation's User Files directory
Sample:
Moving from Toad for Oracle 9.1 to Toad for Oracle 11.5
Take the templates.xml from C:\Program Files\Quest Software\Toad for Oracle\User Files and move a copy into C:\Documents and Settings\<personal folder>\Application Data\Quest Software\Toad for Oracle\11.5\User Files.
Launch 11.5 and Toad will automaticaly convert the file and add the information into Toad 11's Toad Options | Editor | Code Assist | Code Snippets list.