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.
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