This chapter is composed of :
The purpose of this chapter is to show how to generate a Data SQL Script from a Database Data DTD or an existing Database Data resource.
When forwarded to your Database, this script will be able to define data in your Database.
To start the Database Data SQL Script wizard, select :
File->New->Other->Database->Database Data SQL Script
Select an object in the Package Explorer View or the Navigator View then right-click and select :
New->Other->Database->Database Data SQL Script
This wizard has two pages :
This means that if you select an existing Database Data DTD or an existing Database Data resource :
The New Database Data SQL Script page will preset your current Database Data resource.
A new Database Data SQL Script Page will be opened without any selected Database Data resource.
2.1. Database Data SQL Script Page
2.1.1. Script Name
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.
2.1.2. Data Name
Use the Data button :
Select the appropriate Database Data file.
The script generation of the new Database Data SQL Script will be processed and created.
Detailed information is available in the DatabaseConsole window.
Some databases don't support Database Data SQL Script generation.
A message is displayed in the Database Data SQL Script page.
This wizard is Template based.
Below your Plugin Templates or MyTemplates you should see the following directory :
These templates are Velocity based and use the Torque Model API.
Here are several links provided for further Apache Velocity related information.