How do I transfer named sql from one computer to another?
WARNING: Please make necessary backups of the NAMEDSQL.DAT file before modifying.
1. Ensure TOAD is closed.
2. Open Windows Explorer and drill down to the TOAD\TEMPS directory and copy the NAMEDSQL.DAT file from the donor PC to the new PC.
In the case were you need to keep the Original NAMEDSQL and wish to add from another machine, open both NAMEDSQL.DAT files in Notepad and merge the files.
The directory structure and file formatting was changed in Toad for Oracle 8.5. Any subsequent versions store sql in the userfiles directory in a file called savedsql.xml