-
Title
Where is the file that the personal sql, named sql, and sql history saved to located? -
Description
Where is the file that the personal sql, named sql, and sql history saved to located?
-
Resolution
In versions prior to 9.6:
The file is named savedsql.xml and it is located, by default, in the C:\Program Files\Quest Sodtware\Toad for Oracle\User Files directory.
In version 9.6:
The file is named savedsql.dat and it is located, by default, in the C:\Program Files\Quest Software\Toad for Oracle\User Files directory.
In version 9.7 and after:
For WIndows XP, the file is named savedsql.dat and it is located, by default, in the C:\Documents and Settings\<your_user>\Application Data\Quest Software\Toad for Oracle\User Files.For WIndows Vista and 7, the file is named savedsql.dat and it is located, by default, in the C:\Users\<your_user>\AppData\Roaming\Quest Software\Toad for Oracle\10.6\User Files.
-
Additional Information
See SOL42592 on how to convert SavedSQL from a TXT format to XML in order to be used in version 9.6.
See SOL43305 on how to transfer / retain Saved SQL History from a previous version to the current version of Toad. Convert XML to DAT file
See SOL72809 on how to migrate SAVEDSQL.dat from Windows XP to Windows 7.