|
|
|
|
|
|
| Author |
Message |
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
 Posted: Thu Jul 13, 2006 7:32 am Post subject:
DB Schema visualization
|
|
|
Who can recommend a software tool that create a graphical visualizion
of an existing Oracle database schema? (Like displaying all tables as
boxes with their column names and data types inside, and references
such as foreign keys as lines between the tables.)
I would prefer a tool that is free and possibly not Oracle-specific if
there is one.
Any hints are welcome.
Jens |
|
| Back to top |
|
 |
Brian Peasland
*nix forums Guru
Joined: 04 Apr 2006
Posts: 301
|
| Posted: Thu Jul 13, 2006 1:03 pm Post subject:
Re: DB Schema visualization
|
|
|
Jens Lenge wrote:
| Quote: | Who can recommend a software tool that create a graphical visualizion
of an existing Oracle database schema? (Like displaying all tables as
boxes with their column names and data types inside, and references
such as foreign keys as lines between the tables.)
I would prefer a tool that is free and possibly not Oracle-specific if
there is one.
Any hints are welcome.
Jens
|
Visio has a tool that will connect to your database via ODBC and
generate an ERD diagram. It uses the defined FK constraints to know
which tables relate to which tables.
Visio is now owned by M$, and it is not free. However, it is a good tool.
HTH,
Brian
--
===================================================================
Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net
Remove the "nospam." from the email address to email me.
"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown |
|
| Back to top |
|
|
Robbert van der Hoorn
*nix forums beginner
Joined: 29 Jun 2006
Posts: 16
|
| Posted: Thu Jul 13, 2006 1:17 pm Post subject:
Re: DB Schema visualization
|
|
|
"Brian Peasland" <dba@nospam.peasland.net> wrote in message
news:J2CEx6.KL7@igsrsparc2.er.usgs.gov...
| Quote: | Jens Lenge wrote:
Who can recommend a software tool that create a graphical visualizion
of an existing Oracle database schema? (Like displaying all tables as
boxes with their column names and data types inside, and references
such as foreign keys as lines between the tables.)
I would prefer a tool that is free and possibly not Oracle-specific if
there is one.
|
Pitty, Oracle Designer is very capable of doing what you ask here..
| Quote: | Any hints are welcome.
Jens
Visio has a tool that will connect to your database via ODBC and
generate an ERD diagram. It uses the defined FK constraints to know
which tables relate to which tables.
Visio is now owned by M$, and it is not free. However, it is a good tool.
HTH,
Brian
--
===================================================================
Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net
Remove the "nospam." from the email address to email me.
"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown |
|
|
| Back to top |
|
|
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
| Posted: Thu Jul 13, 2006 5:19 pm Post subject:
Re: DB Schema visualization
|
|
|
Robbert van der Hoorn wrote:
| Quote: | Pitty, Oracle Designer is very capable of doing what you ask here.
|
Maybe I should have a look at it.
Is it free? Can I get it alone or do I need to download the whole
Oracle Developer Suite?
And finally, doe the 10g version still support Oracle 9i databases?
(They do offer a 9i version for download, but this is only a
maintenance release that requires an installed full version, which I
did not find for download.)
Jens |
|
| Back to top |
|
|
Sybrand Bakker
*nix forums Guru
Joined: 03 Apr 2005
Posts: 1766
|
| Posted: Thu Jul 13, 2006 6:32 pm Post subject:
Re: DB Schema visualization
|
|
|
On 13 Jul 2006 10:19:14 -0700, "Jens Lenge" <spampot@gmx.net> wrote:
| Quote: | Robbert van der Hoorn wrote:
Pitty, Oracle Designer is very capable of doing what you ask here.
Maybe I should have a look at it.
Is it free? Can I get it alone or do I need to download the whole
Oracle Developer Suite?
And finally, doe the 10g version still support Oracle 9i databases?
(They do offer a 9i version for download, but this is only a
maintenance release that requires an installed full version, which I
did not find for download.)
Jens
|
1 it is free, if it is only for development purposes and you expect no
patches and no support (as per the license no one reads, you agree to
when downloading)
2 You would need to download developer suite
3 You would need to check. Some releases were actually 9i, but had
their version changed in 10g for marketing reasons.
--
Sybrand Bakker, Senior Oracle DBA |
|
| Back to top |
|
|
ThomasO@cpas.com
*nix forums beginner
Joined: 23 Jun 2006
Posts: 2
|
| Posted: Fri Jul 14, 2006 3:08 pm Post subject:
Re: DB Schema visualization
|
|
|
Jens Lenge wrote:
| Quote: | Who can recommend a software tool that create a graphical visualizion
of an existing Oracle database schema? (Like displaying all tables as
boxes with their column names and data types inside, and references
such as foreign keys as lines between the tables.)
I would prefer a tool that is free and possibly not Oracle-specific if
there is one.
Any hints are welcome.
Jens
Try JDeveloper. Free download from Oracle. |
Create Database project , create new Diagram.
Connect to you database, drag and drop tables to you diagram.
HTH
Thomas |
|
| Back to top |
|
|
Robbert van der Hoorn
*nix forums beginner
Joined: 29 Jun 2006
Posts: 16
|
| Posted: Mon Jul 17, 2006 8:42 am Post subject:
Re: DB Schema visualization
|
|
|
<ThomasO@cpas.com> wrote in message
news:1152889686.827422.8220@75g2000cwc.googlegroups.com...
| Quote: |
Jens Lenge wrote:
Who can recommend a software tool that create a graphical visualizion
of an existing Oracle database schema? (Like displaying all tables as
boxes with their column names and data types inside, and references
such as foreign keys as lines between the tables.)
I would prefer a tool that is free and possibly not Oracle-specific if
there is one.
Any hints are welcome.
Jens
Try JDeveloper. Free download from Oracle.
Create Database project , create new Diagram.
Connect to you database, drag and drop tables to you diagram.
HTH
Thomas
|
Right!
And it saves you from going through the process of installation of a
Designer Repository!
Robbert
Robbert |
|
| Back to top |
|
|
bernar
*nix forums beginner
Joined: 18 Jul 2006
Posts: 1
|
| Posted: Tue Jul 18, 2006 10:06 am Post subject:
Re: DB Schema visualization
|
|
|
I recently had the same problem and wasted tons of time on Oracle
Designer, Visio, and Rational Database Architect, in the end I went for
JDeveloper, you can reverse engineer, make changes to the model and
generate SQL script again. It does not loose type formatting (like
Rational) and is easy to use. Some minor improvements I can suggest is
single page printing, but you can always print the JPG to give to
developers.
Regards
Bernard
Robbert van der Hoorn wrote:
| Quote: | ThomasO@cpas.com> wrote in message
news:1152889686.827422.8220@75g2000cwc.googlegroups.com...
Jens Lenge wrote:
Who can recommend a software tool that create a graphical visualizion
of an existing Oracle database schema? (Like displaying all tables as
boxes with their column names and data types inside, and references
such as foreign keys as lines between the tables.)
I would prefer a tool that is free and possibly not Oracle-specific if
there is one.
Any hints are welcome.
Jens
Try JDeveloper. Free download from Oracle.
Create Database project , create new Diagram.
Connect to you database, drag and drop tables to you diagram.
HTH
Thomas
Right!
And it saves you from going through the process of installation of a
Designer Repository!
Robbert
Robbert |
|
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Mon Dec 01, 2008 11:37 pm | All times are GMT
|
|
Remortgages | Direct TV | Free Advertising | Myspace Layouts | Mortgage Calculator
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
