Project Window

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  The DatabaseSpy Interface > Side Windows >

Project Window

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 (see Opening, Saving, and Printing Design Files)
Data comparison files (see Database Data Comparison Files)
Schema comparison files (see Database Schema Comparison Files)
Favorites (see Favorites)

dbs_project_window

Project window

The Project window provides the following commands:

 

Icon

Command name

Description

Create a new project (Ctrl+Shift+N)

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 or comparison windows and project modifications. All editor and comparison windows are set offline.

Open a project (Ctrl+Shit+O)

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.

Save project (Ctrl+S)

Save 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

Add files to the project

Shows the Open dialog box where you can browse for DatabaseSpy documents (SQL files, design files, data comparison files, or schema comparison files) that should be added to the project. Files are added to the corresponding folder in the Project window.

Add the active file

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.

dbs_ic_find

Find

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".

dbs_ic_find_next

Find next

Finds the next occurrence of the specified text.

dbs_ic_find_prev

Find previous

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

Description

Applies to...

Create a new project (Ctrl+Shift+N) New Project

(Ctrl+Shift+N)

Creates a new project.

dbs_anyproject

Open a project (Ctrl+Shit+O) Open Project

(Ctrl+Shift+O)

Opens a project.

dbs_anyproject

Save project (Ctrl+S) Save Project (Ctrl+S)

Saves the project under its current name.

dbs_anyproject

Save Project As...

Opens the Save As dialog box where you can define a new name and/or path for the project.

dbs_anyproject

Add files to the project Add Files to Project...

Opens the Open dialog box where you can select files to be added to the project.

dbs_anyproject

dbs_sql

dbs_sqltemplates

dbs_design

dbs_datadiff

dbs_schemadiff

Add the active file Add Active File to Project

Includes the active file with the project and adds it to its corresponding folder in the Project window.

dbs_anyproject

dbs_sql

dbs_sqltemplates

dbs_design

dbs_datadiff

dbs_schemadiff

Connect to all Data Sources

Connects to all data sources that are included in the project.

dbs_datasources

Disconnect from all Data Sources

Disconnects from all active data sources in the project.

dbs_datasources

Remove all Data Sources

Removes all data sources from the project.

dbs_datasources

Expand | Siblings

Expand | Children

Expands all folders on the same level as, or all children of, the selected item.

dbs_datasources

dbs_sql

dbs_sqltemplates

dbs_design

dbs_datadiff

dbs_schemadiff

Collapse | Siblings

Collapse | Children

Collapses all folders on the same level as, or all children of, the selected item.

dbs_datasources

dbs_sql

dbs_sqltemplates

dbs_design

dbs_datadiff

dbs_schemadiff

Add a new Data Source...

Opens the Add a Data Source dialog box where you can define a new data source connection.

dbs_datasources

Convert all to Global Resources

Converts all data sources in the project to global resources. Note that data source names must not contain blanks.

dbs_datasources

Connect

Connects to the selected data source.

dbs_anydatasource

Disconnect

Disconnects from the selected data source.

dbs_anydatasource

Remove (Del)

Removes the selected item from the project.

dbs_anydatasource

dbs_anyfolder

dbs_anyscript

dbs_anytemplate

dbs_anydesign

dbs_anycomparison

dbs_anyschemadiff

Rename (F2)

Renames the selected item. Note that you can only rename disconnected data sources.

dbs_anydatasource

dbs_anyfolder

Convert to Global Resource

Converts the selected data source into a global resource.

dbs_anydatasource

Copy Global Resource into Project

Creates a copy of the global resource and adds it to the project as a normal data source.

dbs_anydatasource

Edit Global Resource

Opens the Global Resource dialog box where you can edit the global data source connection.

dbs_anydatasource

Create folder Create Folder...

Creates a sub-folder for the selected item.

dbs_sql

dbs_sqltemplates

dbs_design

dbs_datadiff

dbs_schemadiff

Execute all SQL files 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.

dbs_sql

Open

Opens the selected file in its corresponding editor or comparison window, respectively.

dbs_anyscript

dbs_anytemplate

dbs_anydesign

dbs_anycomparison

dbs_anyschemadiff

Locate file...

Opens Windows Explorer so that you can locate the file after it has been moved on the disk.

dbs_anyscript

dbs_anytemplate

dbs_anydesign

dbs_anycomparison

dbs_anyschemadiff

Execute SQL Execute SQL

Opens and executes the SQL file in an SQL Editor window. Note that a data source must be assigned to the file.

dbs_anyscript

dbs_anytemplate

Remove all favorites

Removes all items from the Favorites folder.

dbs_favorites


© 2019 Altova GmbH