Database Designer

[chemuduguntar]

Hi,

Does anyone here know of any Visual Database Designer tools ?  Currently we are using a really big SQL file with all of the DDL statements inside it, this is working fine but all of the documentation for the DDL is embedded in the file as SQL comments and our visuals that we generate are drawn in a seperate program so the ERD diagram and DDL are not always in sync.

So what I am really looking for is firstly a reverse engineering tool to pull the SQL file in and then an SQL generation/mapping tool.

-Ravi


_______________________________________________
NZZUG mailing list
[hidden email]
http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug

[Shaun Hills-3]

Ravi Chemudugunta wrote:

> Does anyone here know of any Visual Database Designer tools ?

Something like Toad?

- Shaun
_______________________________________________
NZZUG mailing list
[hidden email]
http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug

[Campbell Macduff]

Some javascript/style in this post has been disabled (why?)

Hmmmm, I think Navicat from Premiumsoft may do what you're looking for...

Cheers

Cam

--

“What you can do, or dream you can, begin it. Boldness has genius, power and magic in it...” — Goethe

--

Campbell MacDuff, Design Director

NeoGine Communication Design Ltd - Hey, we've moved! Pop in sometime for a coffee ;-)

skype: teamneogine

On 19/02/2008, at 9:31 AM, Ravi Chemudugunta wrote:

Hi,

Does anyone here know of any Visual Database Designer tools ?  Currently we are using a really big SQL file with all of the DDL statements inside it, this is working fine but all of the documentation for the DDL is embedded in the file as SQL comments and our visuals that we generate are drawn in a seperate program so the ERD diagram and DDL are not always in sync.

So what I am really looking for is firstly a reverse engineering tool to pull the SQL file in and then an SQL generation/mapping tool.

-Ravi

_______________________________________________

NZZUG mailing list

[hidden email]

http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug

_______________________________________________
NZZUG mailing list
[hidden email]
http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug

[Danny Adair-2]

http://www.sqlpower.ca/page/architect

_______________________________________________
NZZUG mailing list
[hidden email]
http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug

[chemuduguntar]

hi all, thanks for the quick responses.

All of these products look really great, and this is my fault not mentioning my restrictions: they are that it must be opensource or free, I want to try it out first, has to run on linux and preferably knows about / has a framework for generating DBMS specific code (for e.g. auto_increment in mysql or serial in postgresql).

toad looks really great, from the feature descriptions atleast, is it freeware? does it run on linux too? it doesn't say...i will try to download it

power architect looks really great too and seems to have some knowledge of postgresql, i am going try this out as well.

i came across ArgoUml and DBUML module for it and trying it out now.  ArgoUML seems to be targetted at the very high end - resembling something like rational rose :o

once again, thanks for the links - i will post a reply of my findings if that may help someone.

cheers,

ravi



_______________________________________________
NZZUG mailing list
[hidden email]
http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug

[Shaun Hills]

>   toad looks really great, from the feature
>   descriptions atleast, is it freeware?

There's a free version with less features

>   does it run on
>   linux too?

Don't know. WINE maybe?

Perhaps a better fit for you is DBDesigner:

http://fabforce.net/dbdesigner4/

I've used this as well as Toad. Toad's much better (DBDesigner feels quite beta), but DBDesigner is free and cross-platform.

- Shaun

**********************************************************************
This message  may  contain  confidential  and  privileged information.
If you are not  the intended  recipient please  accept our  apologies.
Please do not disclose, copy or distribute  information in this e-mail
or take any  action in reliance on its  contents: to do so is strictly
prohibited and may be unlawful. Please inform us that this message has
gone  astray  before  deleting it.  Thank  you for  your co-operation.

NHSmail is used daily by over 100,000 staff in the NHS. Over a million
messages  are sent every day by the system.  To find  out why more and
more NHS personnel are  switching to  this NHS  Connecting  for Health
system please visit www.connectingforhealth.nhs.uk/nhsmail
**********************************************************************

_______________________________________________
NZZUG mailing list
[hidden email]
http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug

[chemuduguntar]

hmm I maybe able to try it on vmware.

DBDesigner is quite nice (i've used it for MySQL before), but it is not very good with other DBMS systems, it has support for mysql, oracle and mssql natively but not postgresql (only through odbc) so I doubt it would take care of the differences.  There is an 'userspace' xsi transformation style sheet but I would rather not resort to hacking around right now.

I've started using ArgoUML but it seems a little complicated for my needs - maybe I will look into sqlpower before I commit fully to one product.

thanks for all the suggestions so far, keep them coming.

cheers,

ravi

On Feb 19, 2008 9:19 PM, Hills Shaun (NHS Connecting for Health) <[hidden email]> wrote:

>   toad looks really great, from the feature
>   descriptions atleast, is it freeware?

There's a free version with less features

>   does it run on
>   linux too?

Don't know. WINE maybe?

Perhaps a better fit for you is DBDesigner:

http://fabforce.net/dbdesigner4/

I've used this as well as Toad. Toad's much better (DBDesigner feels quite beta), but DBDesigner is free and cross-platform.

- Shaun

**********************************************************************
This message  may  contain  confidential  and  privileged information.
If you are not  the intended  recipient please  accept our  apologies.
Please do not disclose, copy or distribute  information in this e-mail
or take any  action in reliance on its  contents: to do so is strictly
prohibited and may be unlawful. Please inform us that this message has
gone  astray  before  deleting it.  Thank  you for  your co-operation.

NHSmail is used daily by over 100,000 staff in the NHS. Over a million
messages  are sent every day by the system.  To find  out why more and
more NHS personnel are  switching to  this NHS  Connecting  for Health
system please visit www.connectingforhealth.nhs.uk/nhsmail
**********************************************************************

_______________________________________________
NZZUG mailing list
[hidden email]
http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug

_______________________________________________
NZZUG mailing list
[hidden email]
http://lists.thevirtual.co.nz/cgi-bin/mailman/listinfo/nzzug