Review the following to understand more about Toad files, for example, whether connection information is included in the saved file.
| File Type | Description |
|---|---|
| Export Wizard Template (.txp) |
Saves the current export settings. Although Toad saves connection data with the template, you can change the connection when executing the template. This file opens in the Export Wizard, not in a document window. You can execute the template without opening it by selecting Tools | Import Export Data | Execute Template. |
| Import Wizard Template (.tim) |
Saves the current import settings. Although Toad saves connection data with the template, you can change the connection when executing the template. This file opens in the Import Wizard, not in a document window. You can execute the template without opening it by selecting Tools | Import Export Data | Execute Template. |
| Query Builder File (.tsm) | Saves the current connection and the SQL script. You can save the Query Builder file with or without the result set. In a saved Query Builder file, you cannot change the connection and save it with the file. Even if you execute the file against a different connection the file retains the original connection. |
| Toad Connection Script (.tcs) |
Opens a connection to a specific connection regardless of whether that connection exists in the Connection Manager. This file format is useful when sharing connections between multiple users. |
| Toad Data Report (.tdr) | Saves the SQL script, the connection, and the report layout and options. The query is executed when the report is opened. |
| Toad Editor Files (.tef) | Saves the current connection, SQL script, executed results, and group execute connections/results (if enabled) in a single file. This file format is useful for building scripts that have large result sets that you do not want to continue executing or for saving results when you have not finished building a script. |
| Toad Filters (.tfp) | This file is created when you export Filters from the Object Explorer. |
| Toad Project File (.tpf) | Contains information about the files and projects in the Project Manager. |
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
