SunQuest
           Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Database Management
Reload this Page

Database design software

Discuss Database design software in the Database Management forum on Dev Shed.
Database design software Database Management forum discussing non-database specific SQL. Structured Query Language was designed to be a robust and standardized language for manipulating relational databases.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!
  #1  
Old July 21st, 2003, 04:42 PM
kfickert's Avatar
kfickert kfickert is offline
Capt'n
Dev Shed Novice (500 - 999 posts)
  
Join Date: May 2001
Posts: 539 kfickert User rank is Lance Corporal (50 - 100 Reputation Level)kfickert User rank is Lance Corporal (50 - 100 Reputation Level)kfickert User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 4 h 25 m 4 sec
Reputation Power: 8
Database design software
I have seen others use software that allows you "map" out database design. At least one I saw even would write the "create table (..." queries.

I would like support for MySQL and PosgreSQL if possible, but I am looking for something that is a bit easier than the legal pad and pen method.

Any recomendations? I would prefer something that works in Mac OSX or Windows 9x/XP.
__________________
Why? Because Forms just look cooler in OS X...

Dutch, it's like German...but not!
Last edited by kfickert : July 21st, 2003 at 04:47 PM.
Reply With Quote
  #2  
Old July 21st, 2003, 05:29 PM
Doug G Doug G is offline
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
  
Join Date: Jun 2003
Posts: 10,703 Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level) 
Time spent in forums: 4 Weeks 1 Day 21 h 33 m 53 sec
Reputation Power: 688
I haven't found any at reasonable prices. ErWin & Visio Enterprise are good in a W32 environment, but are priced $1K and up.
Reply With Quote
  #3  
Old July 21st, 2003, 05:32 PM
kfickert's Avatar
kfickert kfickert is offline
Capt'n
Dev Shed Novice (500 - 999 posts)
  
Join Date: May 2001
Posts: 539 kfickert User rank is Lance Corporal (50 - 100 Reputation Level)kfickert User rank is Lance Corporal (50 - 100 Reputation Level)kfickert User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 4 h 25 m 4 sec
Reputation Power: 8
Visio Enterprise sounds familiar. I was planning on spending $150 - 200, but $1000 is a little much for me at the moment.
Reply With Quote
  #4  
Old July 21st, 2003, 05:42 PM
HarrisonF HarrisonF is offline
Contributing User
Dev Shed Novice (500 - 999 posts)
  
Join Date: Oct 2002
Location: Binghamton, NY
Posts: 536 HarrisonF User rank is Sergeant (500 - 2000 Reputation Level)HarrisonF User rank is Sergeant (500 - 2000 Reputation Level)HarrisonF User rank is Sergeant (500 - 2000 Reputation Level)HarrisonF User rank is Sergeant (500 - 2000 Reputation Level)HarrisonF User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Day 15 h 35 m 55 sec
Reputation Power: 19
One very nice tool imo that is also open source is dbdesigner 4. http://www.fabforce.net/dbdesigner4/
It works with MySQL, Oracle, MSSQL and any ODBC databases (should include PostgreSQL in there).

It works on both Windows and Linux which is bonus as well.
Reply With Quote
  #5  
Old July 21st, 2003, 05:58 PM
rod k rod k is offline
Apprentice Deity
Dev Shed Loyal (3000 - 3499 posts)
  
Join Date: Jul 1999
Location: Niagara Falls (On the wrong side of the gorge)
Posts: 3,237 rod k User rank is Private First Class (20 - 50 Reputation Level)rod k User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 4 m 8 sec
Reputation Power: 13
Send a message via AIM to rod k
There's no comparison: DeZign for Databases by Datanamic (http://www.datanamic.com/) can't be beat for the price ($150).
Reply With Quote
  #6  
Old July 21st, 2003, 11:32 PM
Doug G Doug G is offline
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
  
Join Date: Jun 2003
Posts: 10,703 Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level) 
Time spent in forums: 4 Weeks 1 Day 21 h 33 m 53 sec
Reputation Power: 688
Thanks for the links!
Reply With Quote
  #7  
Old July 22nd, 2003, 10:28 PM
kfickert's Avatar
kfickert kfickert is offline
Capt'n
Dev Shed Novice (500 - 999 posts)
  
Join Date: May 2001
Posts: 539 kfickert User rank is Lance Corporal (50 - 100 Reputation Level)kfickert User rank is Lance Corporal (50 - 100 Reputation Level)kfickert User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 4 h 25 m 4 sec
Reputation Power: 8
Thank you. I will try bedesigner first, its free and what do I have to lose? I will check out DeZign too. Sounds like its about what I am looking for if dbdesigner doesn't work.
Reply With Quote
  #8  
Old July 22nd, 2003, 10:45 PM
rycamor rycamor is offline
Gödelian monster
Dev Shed Regular (2000 - 2499 posts)
  
Join Date: Jul 1999
Location: Pembroke Pines, Florida, USA
Posts: 2,300 rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 3 Days 3 h 2 m 4 sec
Reputation Power: 43
There's an interesting project for an open source database deisgner at http://tedia2sql.tigris.org/. It uses Dia, which is mainly aimed at Linux/Unix, but I believe it can work under Windows with cygwin, or possibly Mac OS X.
__________________
The real n-tier system:

FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

Amazon wishlist -- rycamor (at) gmail.com
Reply With Quote
  #9  
Old July 24th, 2003, 12:26 AM
kfickert's Avatar
kfickert kfickert is offline
Capt'n
Dev Shed Novice (500 - 999 posts)
  
Join Date: May 2001
Posts: 539 kfickert User rank is Lance Corporal (50 - 100 Reputation Level)kfickert User rank is Lance Corporal (50 - 100 Reputation Level)kfickert User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 4 h 25 m 4 sec
Reputation Power: 8
I am playing around with dbdesigner now on Win 98SE via Virtual PC on my iBook. Seems to work great for what I need. Its pretty much exactly what I am looking for, but I will take a look at tedia too. Leave no program out of the question
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Database Management > Database design software

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

IBM developerWorks




© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway.