|
Fact
sheet
SQL script to
data model
"ImportER
Scripts" offers the ability to import SQL
files containing DDL statements for tables,
indexes and domains (user defined datatypes)
into the database design tool "DeZign for
Databases". It incorporates a SQL parser that
can derive a graphical data model from such
SQL scripts. You only have to complete four
steps before you can click the button
"generate dezign project file".
Parsing SQL
scripts
When parsing
SQL scripts, "ImportER Scripts" captures
complete specifications for column
definitions, object placement, table
constraints, indexes and object definitions.
"ImportER
Scripts" recognizes the following objects:
- Tables
- Columns of
tables including:
- Column
name
- Data
type
- Not null
constraints
- Unique
constraints
- Primary
key constraints
- Foreign
key constraints (relationships)
- Check
constraints
- Default
values
- Extra
properties such as ZEROFILL,
AUTO_INCREMENT, UNSIGNED
-
Tableconstraints:
- Primary
key table constraints
- Foreign
key table constraints
- Check
constraints at table level
- Unique
table constraints
-
Domains/User defined data types
- Alter
table statements
- Comments
- Indexes
- Triggers
- Stored
procedures
- Sequences
and generators
- Integrity
constraints
Supported
databases
"ImportER
Scripts" can import SQL scripts for the
following databases:
- Oracle
- Interbase
- IBM DB2
- MySQL
- MS SQL
Server
- Informix
- SQL
Anywhere
- PostgreSQL
- Sybase
-
PervasiveSQL
System
requirements
"ImportER
Scripts" is available as a 32-bit application.
The product is available for Windows 95 or
later, Windows NT, Windows 2000 and Windows
XP. "ImportER Scripts" requires a minimum of
8MB RAM. Disk space requirement is 4 MB. "DeZign
for Databases" must be installed on your PC.
|
