DBA Tip of the Month
Date: Fri, 18 May 2001 18:17:37 GMT
Message-ID: <5HdN6.7950$6j3.663512_at_www.newsranger.com>
Subscribe to the Pipeline Newsletter for monthly articles and tips
about Oracle & DB2 technology.
http://www.revealnet.com/newsletter-v2/newsletter_0501.htm
MAY TIP OF THE MONTH: Solving Designer Compatibility Problems with ERDs
Compliments of Victor Slootsky (slootsky_at_erols.com)
If you have had to copy a very sophisticated Entity Relational Diagram (ERD) from Designer 6.0 on one machine to Designer 6i on another machine, you know that this is not an easy task.
The Oracle provided migration procedure is very complicated. It usually takes at least an entire working day to complete, and you have to be extremely careful to follow the sequence of steps in the instructions. I have developed a new approach which is simple and straightforward.
Below are five simple steps to implement this new method. It takes about an hour to complete the task.
- Create a new schema in the old Oracle database where Designer 6.0 resides
- From Designer 6.0 generate tables to this schema
- Export the schema into the export dump file
- Import the schema from the export dump file to the new Oracle database where Designer 6i resides
- Finally, capture the imported schema from the Oracle database into the Designer 6i Entity Relational Diagram
Best wishes,
Cam White
RevealNet
Received on Fri May 18 2001 - 20:17:37 CEST