reverse engineering data model

Can rational rose reverse enginner data model from database (i.e. read the schema in db and then generate the ER diagram)?
[129 byte] By [it_qooa] at [2007-9-29 16:08:37]
# 1

Yes you can reverse engineer datamodel from database. Following steps will help you in doing it. I did it using Rational Rose 2001(a) Enterprise suite edition.

1. Go to Tools->DataModeler->Reverse Engineer option

2. Reverse engineering wizard dialog box will be shown.

3. Select Reverse engineer from Database

4. Select your target database. Enter username/password and service name

for your database.

5. Test connection option is also provided. You can test the connection using this option.

6. Available schemas in the selected database will be displayed.

7. Select the schema of your choice and it will generate the datamodel.

Hope it helped you.

yetisha at 2007-7-15 14:19:53 > top of Java-index,Other Topics,Patterns & OO Design...
# 2
Thanks, I've tried but it said "unable to connect". Do you know any trick?I am using OracleThanks in advance
it_qooa at 2007-7-15 14:19:53 > top of Java-index,Other Topics,Patterns & OO Design...
# 3

Hi,

Then the classpath for the database drivers will not be set. Go to

Tools->Java2/J2EE->Project Specification.

Make sure the classpath list contains classes12.zip. If it does not contain add it. Now repeat the steps mentioned for reverse engineering of databases. Some times the classpath change will not reflect while reengineering. If you face the problem, close the application and run it again. This time the classpath change will be reflected.

Yetish

yetisha at 2007-7-15 14:19:53 > top of Java-index,Other Topics,Patterns & OO Design...
# 4
I have added the classes12.zip in the classpath and set it as reference. I tried Tools -> Oracle 8 -> Analyse Scheme and it can reverse engineer a Oracle scheme. But if I user Tools -> Data Modeler -> Reverse Engineer it still said "Unable to connect".
it_qooa at 2007-7-15 14:19:53 > top of Java-index,Other Topics,Patterns & OO Design...
# 5
The steps mentioned are really helpful but I would also like to know how to generate an ER Diagram from this data model generatedThanks in advance.
jacobjinua at 2007-7-15 14:19:53 > top of Java-index,Other Topics,Patterns & OO Design...