. : (Transformation Model) .
, . , , , . , .
, , . .
:
, ;
;
, .
, . ERWin . , .
. Target Server ( Server/ Target Server ).
. 4.1.
ERwin , 20 . .
Target Server NULL , , . Default Access Datatype, , .
Default Non-Key Null Option NULL .
ERwin . (. 4.1). Yes.
, (view)
ERwin , , . , , . , Tables Columns, , ERwin .
|
|
Tables , , , , . . (. 4.2).
.4.2. Tables
Name . Owner , , . Physical Only . Generate, CREATE TABLE. DB Sync . Tables :
Comment. .
Volumetrics. .
UDP. , .
Validation. .
, , Columns (. 4.3). , Columns.
ERwin , , Target Server. NOT NULL. NOT NULL (Inversion Entry).
. 4.3. Columns
Columns Attributes. :
General. , .
, . . , NULL, . Valid Default.
Comment. .
UDP. , .
Index. .
. . New, Rename Delete , . Reset , , . PB Sync .
(Forward Engineering). ERwin , , , . (Reverse Engineering). ERwin . , ( ) . ERwin .
|
|
Tools/Forward Engineer/Schema Generation . Schema Generation (. 4.4). Schema Generation 3 :
Options. , , , , . . - , .
Summary. , Options. Summary , Options.
Comment. .
( Option Set, New, Rename Delete) .
Preview Schema Generation Preview (. 4.4) SQL-, ERwin . Generate .
Print Schema Generation ERwin SQL-.
Report ERS- SQL- . .
Generate . , - , SQL-. Generate Database Schema.
. 4.4. Schema Generation Preview
Generate Database Schema Stop If Failure. , . Continue, . Abort . Stop If Failure , .
Tools/Reverse Engineer.
Reverse Engineer Select Template, , , , Reverse Engineer Set Options.