Altova DatabaseSpy 2024 Professional Edition

A database project in DatabaseSpy allows you to store SQL files together with the database connection in one project file so that you have all the files and connections you need at hand when you open a project in DatabaseSpy. In this step, you add the SQL scripts to the project that you will later use to create the tables for the zoo database and to query the "Zoo" database.

To add the SQL files to the project file:

1.In the Project window, right-click the SQL folder and select Add Files to Project... from the context menu. The Open dialog appears.

2.Select the files to be added to the SQL folder from the tutorial directory:

 

animalType_queries.sql

create_ZooDB_relationships.sql

create_ZooDB_tables.sql

tblAnimalTypes_data.sql

 

3.Click Open. The SQL files appear in the SQL folder of the Project window.

dbs_zoo_tutorial_08

© 2017-2023 Altova GmbH