ERwin datamodeler - complete compare

Ram Hanuman Achutānanda

ERwin datamodeler - complete compare

I am trying to compare the ERwin datamodel from local(Left Model) to the Database(Right Model) using Complete compare--Compare option.

The Database(Right Model) is loaded using the Database/Script option.
On executing the compare, the "Resolve Differences" pops-up and show the differences not limited to databases, directories, functions, packages, rollback segments, sequences, stored procedures, tables, tablesspaces, views and so on...

Focussing on the "Tables" differences observed, there are many properties shows like cache, column order, comment, compress type, database column order, enable row movement, row dependencies, use parallel and so on...

I see an option of "Copy Item(s) to the Right" & "Copy Item(s) to the Left" on selecting a table difference.

1) What will happen if I click on the "Copy Item(s) to the *****" option? Will changes be implemented into the actual Database?
2) Can I generate scripts using ERwin/SQL Navigator/SQL Plus so that the changes can be implemented in actual database?

Please let me know if I missed any information. Many Thanks in advance!

Daniel Luksetich

ERwin datamodeler - complete compare
(in response to Ram Hanuman Achutānanda)
Hello,

Please update your IDUG profile with your precise First and Last name.

Thanks,

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: Sam Sam Sam [mailto:[login to unmask email]
Sent: Tuesday, February 27, 2018 11:21 AM
To: [login to unmask email]
Subject: [DB2-L] - ERwin datamodeler - complete compare



I am trying to compare the ERwin datamodel from local(Left Model) to the Database(Right Model) using Complete compare--Compare option.

The Database(Right Model) is loaded using the Database/Script option.
On executing the compare, the "Resolve Differences" pops-up and show the differences not limited to databases, directories, functions, packages, rollback segments, sequences, stored procedures, tables, tablesspaces, views and so on...

Focussing on the "Tables" differences observed, there are many properties shows like cache, column order, comment, compress type, database column order, enable row movement, row dependencies, use parallel and so on...

I see an option of "Copy Item(s) to the Right" & "Copy Item(s) to the Left" on selecting a table difference.

1) What will happen if I click on the "Copy Item(s) to the *****" option? Will changes be implemented into the actual Database?
2) Can I generate scripts using ERwin/SQL Navigator/SQL Plus so that the changes can be implemented in actual database?

Please let me know if I missed any information. Many Thanks in advance!



-----End Original Message-----