All ImportERs pursue the same object :
offering the ability to import an existing
database into the database design design tool
"DeZign for databases". This is called
"reverse engineering". An ImportER generates a
DeZign project file that holds your data
model/ER Diagram. We have different ImportERs
because all database types (database vendors)
are different. Each database type requires a
different approach to be able to read the
structure of your database.
All SQL
databases like
Oracle
Interbase
MySQL
Pervasive
PostgreSQL
Firebird
IBM DB2
Informix
MS SQL Server
Sybase
The input
is a SQL script containing CREATE TABLE
statements. Such a script is called a
database structure dump. Most of the
times you can create a database
structure dump of your database with the
tools that came with the database.
ImportER
Tables will make a connection to the
database by using the (free) Borland
Database Engine (BDE).
The
input is your database directory
(location of the .dbf or .db files). The
structure reader opens the tables and
will get table structure information by
using the BDE.
The
input is your MS Access database file (.mdb).
The structure reader opens the tables
and reads the table structure
information. Relationships information
is obtained from the "MSYSRelationships"
system table.
Native
connection to your MySQL database. No
extra files/installation necessairy.
The
input is your MySQL database name, host
name and log in data. The structure
reader then opens the tables and reads
the table structure information.
