Click here to Skip to main content
Rate this: bad
good
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
sp1786668

1 solution

Rate this: bad
good
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 http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html[^]. 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 Smile | :)
 
Hopefully the tool or entity framework could be of help.
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 8,478
1 OriginalGriff 6,516
2 Peter Leow 3,587
3 Zoltán Zörgő 3,406
4 Richard MacCutchan 2,397


Advertise | Privacy | Mobile
Web03 | 2.8.150123.1 | Last Updated 25 Sep 2012
Copyright © CodeProject, 1999-2015
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