The Project window displays files and other items that you have added to your project, which include:
•Data sources (see Adding Data Sources)
•SQL files (see Adding Files)
•SQL templates (see SQL Templates)
•Design files (Opening, Saving and Printing Diagrams)
•External files (files external to DatabaseSpy that you can open in the application with which they are registered)
•Favorites (see Favorites)
The Project window provides the following commands:
Create a new project
Closes the active project in the Project window and displays a new, empty project. If a project contains unsaved changes when you click this button, a dialog box appears and you can choose to save changes in the editor window and project modifications. All editor windows are set offline.
Open a project
Shows the Open Project dialog box where you can choose a *.qprj file to open in DatabaseSpy. If there is an unsaved project already open in the Project window, you are prompted to save this project.
Saves the project under its project name. If you save a new project for the first time, the Save As dialog box is displayed where you can specify a project name and choose a location. The project name then also appears in the Project window.
Add files to the project
Shows the Open dialog box where you can browse for DatabaseSpy documents (SQL files, design files) that should be added to the project. Files are added to the corresponding folder in the Project window.
Add the active file
Adds the active file to the project. If the file has not been saved yet, you are prompted to enter a name and location for the file. The file is then added to the corresponding folder in the Project window.
Finds a project item by name. Wildcards can be used in the search. For example, the search term "Pr*ject" will find an item called "Project".
Finds the next occurrence of the specified text.
Find the previous occurrence of the specified text.
Depending on where you right-click into the Project window, different options are displayed in the context menu. The same context menu command may be available in multiple places (as shown in the "Applies to" column below).
Context menu command
Creates a new project.
Opens a project.
Save Project (Ctrl+S)
Saves the project under its current name.
Save Project As...
Opens the Save As dialog box where you can define a new name and/or path for the project.
Add Files to Project...
Opens the Open dialog box where you can select files to be added to the project.
Add Active File to Project
Includes the active file with the project and adds it to its corresponding folder in the Project window.
Connect to all Data Sources
Connects to all data sources that are included in the project.
Disconnect from all Data Sources
Disconnects from all active data sources in the project.
Remove all Data Sources
Removes all data sources from the project.
Expand | Siblings
Expand | Children
Expands all folders on the same level as, or all children of, the selected item.
Collapse | Siblings
Collapse | Children
Collapses all folders on the same level as, or all children of, the selected item.
Add a new Data Source...
Opens a dialog box where you can define a new data source connection.
Convert all to Global Resources
Converts all data sources in the project to global resources. Note that data source names must not contain blanks.
Connects to the selected data source.
Disconnects from the selected data source.
Removes the selected item from the project.
Renames the selected item. Note that you can rename data sources only if they are disconnected.
Convert to Global Resource
Converts the selected data source into a global resource.
Copy Global Resource into Project
Creates a copy of the global resource and adds it to the project as a normal data source.
Edit Global Resource
Opens the Global Resource dialog box where you can edit the global data source connection.
Creates a sub-folder for the selected item.
Execute All SQL Files
Opens all SQL files that are contained in the SQL folder in new SQL Editor windows and executes them automatically. Note that a data source must be assigned to the files.
Opens the selected file in its corresponding editor window, respectively.
Opens Windows Explorer so that you can locate the file after it has been moved on the disk.
Opens and executes the SQL file in an SQL Editor window. Note that a data source must be assigned to the file.
Remove all favorites
Removes all items from the Favorites folder.