?
Solved

Can anyone recomend me to a good free tool to create a database schema diagram.

Posted on 2011-02-24
11
Medium Priority
?
343 Views
Last Modified: 2012-05-11
I need to create something like an ERD showing the Entities,fields,relationships(one to many etc) and data types etc.
I need to be able to export the diagram as a word document.
0
Comment
Question by:wademi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 10

Accepted Solution

by:
GDG_DBA earned 2000 total points
ID: 34975113
MS Visio does a nice job if you have access to it.
-G
0
 

Author Comment

by:wademi
ID: 34975126
I clearly said free tool.
0
 
LVL 22

Expert Comment

by:pivar
ID: 34975150
Hi,

I've used DB Visualizer http://www.dbvis.com/products/dbvis/download/
only in the combination Linux/MySql though.
Should also work for Win/MSSQL.

/peter
0
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 
LVL 10

Expert Comment

by:Mez4343
ID: 34975160
Visio is good

I would also recommend MS Access since you can actually prototype the tables, relationships, indexes, add some data, to see what it looks like instead of just modeling it. Access can produce prinable reports including Relationship report that you can then edit in the Report designer.

0
 
LVL 10

Expert Comment

by:GDG_DBA
ID: 34975162
Sorry, It's not free.  However, you may already have it, and certain versions do ERDs.
-G
0
 
LVL 10

Expert Comment

by:GDG_DBA
ID: 34975178
>>>I clearly said free tool.

Clearly, I'm sorry I offered.
0
 
LVL 8

Expert Comment

by:PranjalShah
ID: 34975241
Here is a FREE tool for the first 30 days..

http://www.webyog.com/en/downloads.php

Download the trial version.. You will be able to design your schema...
0
 
LVL 79

Expert Comment

by:arnold
ID: 34975311
mysql's workbench  mysql.com
You may have to do some translation in few/minimal cases.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34976433
How about SSMS?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34976442
>>I clearly said free tool. <<
And clearly out of order or just not looking for a serious answer.
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 34986215
hi

here is a list of programs for ERD some of are complitly free.

http://www.databaseanswers.org/modelling_tools.htm
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question