Click here to Skip to main content
12,697,850 members (24,422 online)
Rate this:
Please Sign up or sign in to vote.
See more: Oracle
I have a application with front end and backend in Oracle.
However, as of now i am just provided with database schema made in Oracle. No front end. How do i study this schema.. all i see is tables,views triggers...etc.. also no database diagram is available so that i can see how different tables are linked... Please guide...
Posted 25-Sep-12 2:38am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

If you are using Visual Studio 4.0 (not sure about 3.5) and you have enough right to access the database, you could use the Entity Framework for it. It is discribed on this page Use Entity Framework with Oracle Data Provider for .NET[^]. Generate a model from the database and you have a database diagram you could use.

While searching for a free tool I found this one[^]. I looks like it is possible to import a database. At least there is a demo about it. You could Google to search for other tools.

I'm not sure what you could do when there is some reason that you can't reach the database. Analysing it manually could be a last resort. Draw the diagram yourself in a tool like Visio or use good old pencil and paper :)

Hopefully the tool or entity framework could be of help.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170118.1 | Last Updated 25 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100