(Forward Engineering). ERwin , , , , . (Reverse Engineering). ERwin . , ( ) . ERwin .
Tools/Forward Engineer/Schema Generation . Schema Generation (. 1).
. 1. Schema Generation
Schema Generation :
Options. - , , , , . . - , (. . 1).
Summary , Options. Summary , Options.
Comment. . ( Option Set, New, Rename Delete) .
Preview Schema Generation Preview (. 2), SQL-, ERwin . Generate .
. 2. Schema Generation Preview
Print ERwin SQL-.
Report ERS SQL . .
. 3.
Generate . (. 3), SQL-. Generate Database Schema (. 4).
. 4. Generate Database Schema
Generate Database Schema Stop If Failure. , . Continue . Abort . Stop It Failure , .
Tasks/Reverse Engineer.
|
|
ERwin Template Selection (. 5), , , , Reverse Engineer - Set Options (. 6).
. 5. ERwin Template Selection
Reverse Engineer - Set Options :
Reverse Engineer From - SQL(DDL)-CKpHnT. Browse , SQL-.
Items to Reverse Engineer , . Option Set, a New, Update Delete , .
Reverse Engineer ( ) ( System Objects) .
Primary Keys Infer , ERwin . Relations, ERwin . , .
Case Conversion .
. 6. Reverse Engineer - Set Options
Import View Base Tables , ERwin . SQL- (, ), .
Next, (. . 3), , Reverse Engineer-Status. .
. , . .
Tasks/Complete Compare . Complete Compare - Set Options, Reverse Engineer - Set Options. , SQL-, ERwin, ModelMart.
Next Complete Compare - Set Options (. . 3), Complete Compare - Resolve Differences () () (. 7).
. 7. Complete Compare - Resolve Differences
|
|
, :
;
;
( );
.
Match UnMatch , . , ERwin CUSTOMER CUST . ERwin , , . ERwin , . Match, ( ) , , ( ). UnMatch .
.
Report, , Preview Preview SQL Commands, SQL-, .
Next Complete Compare -Import Changes, , (. 8).
Case Conversion of Logical Names .
If Table to Import Exists in Model , . (Use Existing Table) (Create Duplicate Table).
Primary Keys, Relations Import Base Tables , Reverse Engineer - Set Options (. ).
. 8. Complete Compare - Import Changes
Start Import , SQL(DDL)-, ModelMart ER1/ERX. ERwin .