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.

• Database Connection
• Database SQL Script
• Database Create SQL Script
• Database Diagram
• Database Schema SQL Script
• Database Data DTD and XML Resources
• Database Data SQL Script

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 :

• Database SQL Script
• Database Create SQL Script
• Database Diagram
• Database Schema SQL Script
• Database Data DTD and XML Resources

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.