This chapter is composed of :
The purpose of this chapter is to show how to generate a Schema SQL Script.
When forwarded to your Database, this script will be able to define the Meta Data of your Database.
To start the Database Schema SQL Script wizard, select :
File->New->Other->Database->Database Schema SQL Script
or
Select an object in the Package Explorer View or the Navigator View then right-click and select :
New->Other->Database->Database Schema SQL Script
The selection is contextual.It means that if you select an existing Database Object :
The wizard will open the parent Database Connection in update mode.
Otherwise :
A new Database Connection wizard will be opened starting with a New Folder selector.
In Database Connection Update mode this wizard has four pages :
In Database Connection Create mode this wizard has five pages :
2.1. Database Schema SQL Script Page
Script Name is the name of your new SQL script.
Each resource should have a unique name in the targeted selected workspace folder or project root.
This data is not related to any Meta Data information.
This name will be the file name of the generated SQL file.
Its file extension is :
This file is referenced in your current Database Connection.
The script generation of the new Database Schema SQL Script will be processed and created.
Detailed information is available in the DatabaseConsole window.
Some databases do not support Database Schema SQL Script generation.
In this case a message is displayed in the Database Connection page.
This wizard is Template based.
Below your Plugin Templates or MyTemplates you should see the following directory:
Torque/sql/base
These templates are Velocity based and use the Torque Model API.
