Setting Up a Database Project

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

Home >  Tutorials > "ZooDB" Database >

Setting Up a Database Project

Project files organize everything you need in order to work on your database projects. You can store the following items in a project file:

 

Database connections
SQL scripts
SQL templates
Design files
Database Data Comparison files
Database Schema Comparison files
Favorite database objects

 

Objective

In this section of the tutorial, you will learn how to create a project in DatabaseSpy and connect to a database. Specifically, you will learn how to do the following:

 

Create a new project and add a data source connection
Add SQL files
Change the project name
Define the project startup options

 

Commands used in this section

Icon

Command name

Description

ic_quick-connect

Create a Database Connection

This command is located in the Standard toolbar and in the File menu. Click this command to open the Add a Data Source dialog box that allows you to connect to any database supported by DatabaseSpy.

ic_add_sql_file

Add files to the project

This command is located in the toolbar of the Project window. Click this command to open the Open dialog box where you can choose the files to be added to and stored with your database project.

ic_save_project

Save Project

This command is located in the toolbar of the Project window; alternatively, you can also choose the menu option File | Save Project As... or press Ctrl+S. Click this command to save an existing project under its project name or to specify a name and path for a new project, respectively.

ic_show-design-options

Options

This command is located in the Tools menu. Click this command to open the Options dialog box where you can define the project startup options.


© 2019 Altova GmbH