Modeling in the Workspace


This chapter is composed of :

  1. Introduction
  2. Drag and Drop
    1. Introduction
    2. Drag and Drop
  3. Database Connection
    1. Introduction
    2. New Database Connection
    3. Database Connection Update
    4. Refresh
    5. Reverse
  4. Database SQL Script
    1. Introduction
    2. Database SQL Script
  5. Database Create SQL Script
    1. Introduction
    2. Database Create SQL Script
    3. Templates
    4. Additional Resources
  6. Database Diagram
    1. Introduction
    2. Database Diagram
  7. Database Schema SQL Script
    1. Introduction
    2. Database Schema SQL Script
    3. Templates
  8. Database Data DTD and XML Resources
    1. Introduction
    2. Database Data DTD and XML Resources
    3. Templates
    4. Additional Resources
  9. Database Data SQL Script
    1. Introduction
    2. Database Data SQL Script
    3. Templates
    4. Additional Resources
  10. Forward
    1. Introduction
    2. Forward
  11. Import Existing DDL SQL file
    1. Introduction
    2. Import Existing DDL SQL file
    3. Additional Resources
  12. Index
    1. Introduction
    2. Index

1. Introduction

You will learn in this chapter how to work with Databases inside the Eclipse Workspace.

EclipseDatabase proposes several wizards who will help you to manage your database work.

There are several ways to run a wizard.

File->New->Other->Database

or

Select an object in the Package Explorer View or the Navigator View then right-click and select :

New->Other->Database

 

 

The difference between these two ways of running a wizard is the context.

Every time you start a wizard, EclipseDatabase knows where you are coming from.

For example here is the exact behaviour of the following wizards :

If you start one of these wizards while selecting a Database Connection file, a Database Schema file or any file belonging to a Database Connection, EclipseDatabase will pre-set this connection.

 

 

This will open a new Database Create SQL Script set of wizard pages pre-set to your selected Database Connection.

 

 

 

Otherwise:

 

 

This will open a new Database Create SQL Script with a target selector.

 

 

This way of working means that you can modify a current connection (Connection, Schema and DTD) while you fill the target of a specific wizard.

To analyse the context EclipseDatabase use an Index to retrieve the Database information.