Importing a Database Schema
To import a database schema into FireStorm/DAO, you must create a new project (select "New" from the toolbar or the "New" menu option under the "File" menu) and then select one of the options in the "Database" menu as shown below:
Importing Schemas from JDBC
Step 1: Select Data Source
To import a schema from JDBC, choose the "Import schema from JDBC" menu option under the "Database" menu. You are presented with the following dialog:
Choose the data source that you want to import from and select the Next>> button.
Step 2: Select Schema
You are then presented with a list of schemas within the database:
Choose the schema from which you want to import and select the Next>> button.
Step 3: Import Options
You are then presented with additional options:
You can choose to import tables, views, or both tables and views. You can also choose if you want to map simple types such as integers to Java native types such as int or to object types such as java.lang.Integer. Some developers have specific preferences on this issue. If you do not have any specific preference, you should use the default setting.
After you have confirmed the settings, select Next>>.
Step 4: Select Individual Tables and Views
This dialog enables you to select individual items you want to import from the database (the default setting is to inport all tables):
If you are using FireStorm/DAO Enterprise Edition or Architect Edition, and you are using a full (rather than evaluation) license, you are able to choose which tables and views to import. If you are using a FireStorm/DAO evaluation license the only option available is to import partial schema.
After you are have confirmed your selection, select the Next>> button.
Step 5: Synchronization Settings
You are then asked how you want to synchronize the project file with the schema being imported as follows:
If you are importing into a new project file, you can ignore this dialog and select the Finish button. If you are synchronizing with an existing project file that you have modified since importing the schema, you must carefully choose the appropriate options in the dialog that is presented.
Import Completed
After the import has completed, the project file displays the imported table and view definitions.
You may now proceed to the next section in the tutorial:
or: