Database Projects Organize Database Management Tasks

Working with database projects in Altova DatabaseSpy

Database Projects in DatabaseSpy

A DatabaseSpy® 2017 project file is a toolbox for collecting database connections along with your favorite tables, views, SQL statements, and visual database design files. When you launch Altova DatabaseSpy and connect to any of its supported database types, your work is automatically organized as a project.

A DatabaseSpy project file makes it easy to organize all the files related to your database work and to restore quick access to them later. The DatabaseSpy Project helper window displays the contents of the project in hierarchical format regardless of where individual files may be – on your local workstation or across the network.

Each major element of DatabaseSpy can contribute to a project: your Data Sources, SQL files, Design files, and Comparison files. You can connect to any database or open any file from the Project window without having to rebuild the database connection string or browse for the file location.

As your project grows to encompass multiple database connections and numerous files, you can drag and drop to reorder the list of project components and you can create folders and subfolders that individually collapse or expand to group SQL files and designs as you wish. DatabaseSpy lets you organize your project in a convenient hierarchy that is saved and restored when you later reopen the project file.

Download Trial

Supported Databases:

  • Firebird 2.5
  • IBM DB2 for iSeries® v6.1, 7.1
  • IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
  • Informix® 11.70
  • Microsoft Access™ 2003, 2007, 2010, 2013
  • Microsoft® Azure SQL
  • Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
  • MySQL® 5, 5.1, 5.5, 5.6
  • Oracle® 9i, 10g, 11g, 12c
  • PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
  • Progress OpenEdge 11.6
  • SQLite 3.x
  • Sybase® ASE 15

Properties Window

The DatabaseSpy Properties window below the Project window displays and lets you edit information about each component in the project.

For SQL files included in your project, for instance, the Properties window shows which database the file is assigned to for execution. After you have completed, tested, and verified a new SQL script against a test database, you can use the Data Source pull-down menu in the Properties window to reassign the target to your live database.

No matter what your immediate task, the Properties window shows all the details for any database component you select.

Project File Features:

  • Organize commonly-used items all in one place
  • Reopen database connections with one click
  • Store frequently-used SQL queries for reuse
  • Conveniently relaunch database comparisons
  • Store design files that illustrate table relationships
  • Share access to commonly used items among team members
Properties helper window for a database project in Altova DatabaseSpy