Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Organize Information in Projects

Project Manager

Use the Project Manager to conveniently group and organize files and other items you create in Toad into projects. A project can consist of Toad documents, Data Reports, scripts, diagrams, and other files that you save and store in many different locations. You can save a SQL statement, a database connection, and nearly any Toad output or exported file and add it to a project as you work.

Note:

A default project named Project is included with Toad. You can rename or remove the default project; however, at least one project must exist in the Project Manager.

To create a project in the Project Manager

Select View | Project Manager (ALT+V+P).
Click in the Project Manager toolbar.
Enter a name for the project.

To add items to a project using the Project Manager

Right-click a project or folder, select Add, and then select from the following:

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. 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 script and add it to a project

Open the project in the Project Manager window.
With the Automation script window open, select from the Automation toolbar. Toad saves the script as a file to the location you select and also adds the script to the open project (in a special folder).

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:
- Right-click the table and select Send To | Project Manager.
- Select the table and click in the Explorer toolbar.

To open a file from the Project Manager window

Do one of the following:

Right-click a file and select Open. The file opens in its own window in Toad.
Right-click a file and select Browse. The file's location folder opens in a Windows Explorer window with the file selected.

To store a value for a Bind Variable

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.

Click in the Project Manager toolbar.
Enter a name and a value for the bind variable, and specify a data type.

Note: See Set Bind Variables for more information.

Tips:

To share a project file with other users, right-click the file and select Send To | Shared Toad. You can specify a shared network directory in Network Share Options (Tools | Options | Environment | Network Share).
To sort items in a project or folder, right-click the project or folder and select Sort. Items are sorted in alphabetical order.
Drag and drop to move folders and items to different nodes within a project.
To run a script from the Project Manager, right-click the script and select Execute.
To quickly add objects to a project, right-click the object in the Object Explorer, and select Send To | Project Manager.
To open a different project, click the arrow next to the current project name in the Project Manager toolbar.
Several Automation activities allow you to easily select files from an open project, so you can use the Project Manager to store files to be used in Automation scripts.