Use the Project Manager to conveniently group and organize files and other resources into projects. These resources can include Toad documents (Query Builder files, ER Diagrams, Toad Data Reports, Editor files), Automation scripts, database objects, database connections, URLs, directory shortcuts, SQL scripts, Toad Views, executables, Excel files, etc. You can save nearly any Toad document or exported file and add it to a project as you work. You can even add To-Do lists.
The file resources you add can be files saved and stored in a variety of locations. When you add a file to a project, a link to the file's current location is added. The file is not copied or moved.
In addition to the Project Manager, you can organize Toad documents and other files using the Library. See Organize Files Using the Library for more information.
Note:
To create a project in the Project Manager
Select View | Project Manager (ALT+V+P).
To add items to a project using the Project Manager
New Folder | Adds a new folder that you can use to group resources within the project. |
Directory (Links) |
Adds a link to a system folder in the project. You can click the link to open Windows Explorer in Toad, and then select a file to open. |
Directory Items |
Adds the contents of the selected system folder and any subfolders to the project. Note: You cannot add directory items to the project node. You must first create a folder, and then add the directory items to it. |
Existing File |
Adds a file to the project, including the following types: queries from Query Builder,Database Diagrams, Automation scripts, executables, Excel spreadsheets, Word files, and SQL scripts. A link to the file is added to the project. Tip: You can double-click any file to open it. |
FTP Connection |
Adds a connection to an FTP server. After creating a connection, double-clicking this item opens a window from which you can upload, download, and manage files between the server and your local computer. |
URL |
Adds a URL to the project. You can right-click a URL and select Rename to give the URL a user-friendly name. Tip: You can double-click any URL to open it. |
Database Connection |
Adds an existing database connection. Note: After adding a connection, right-click the connection to connect or disconnect. |
To-Do List |
Adds a node to group to-do items. |
To-Do Item |
Adds a note regarding a project task. Tip: You can double-click the note to add details or set a due date. When you complete a To Do item, select the checkbox beside its node. If you do not select the checkbox by the due date, the caption displays in red. |
Named SQL |
Adds executed SQL statements that you saved as Named SQL in SQL Recall. See Recall SQL Statements for more information. |
To save a Toad file and add it to a project as you work
Select a local or networked directory in which to save your work as a sql, script, or Toad file. Toad saves the file and also adds it to the open project (in a special folder).
Note: When adding scripts, queries, and other Toad files to a project in this way, Toad creates special folders in the project for these files.
To add a database connection to a project
To add a Toad View to a project
To add a table or database object to a project
Open the project in the Project Manager window and select a destination folder.
Then, in the Object Explorer, do one of the following:
To open a file from the Project Manager window
Do one of the following:
You can use this feature in the Project Manager to store a value for a bind variable. Then, when you execute a SQL statement containing that bind variable, Toad will not prompt you for a value.
To store a value for a Bind Variable
Note: See Using Bind Variables for more information.
The Project Manager uses a project manager (.tpf) file to store the information about the projects you create and manage in the Project Manager. One project manager file can include the information for multiple projects. Toad comes pre-loaded with a default project manager (.tpf) file named ProjectManager.tpf. This file includes the information for the default project, Sample Project.
When you create a project in the Project Manager, the project is added to the currently-loaded project manager (.tpf) file. Initially, this is the ProjectManager.tpf file.
You can create additional project manager (.tpf) files, if necessary. Only one project manager (.tpf) file can be loaded into the Project Manager at one time. But one project manager (.tpf) file can contain multiple named projects.
To create additional project manager (.tpf) files, perform a Save As action on the default file, ProjectManager.tpf.
To create an additional project manager (.tpf) file
Note: You can specify a default location for the currently-loaded .tpf file in Tools | Options | Environment | Network Share. See Network Share Options for more information.
To load a saved project manager (.tpf) file
Click the arrow beside and select a project manager (.tpf) file from the list of saved files.
Note: A .tpf file appears in this list only if it was opened in a current or previous Toad session.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center