473,406 Members | 2,369 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

MySQLdump to data model graphical table layout.

dlite922
1,584 Expert 1GB
I thought Toad Data Modeler would do this, but the free one does not.

Do you know if any Free applications that takes a table structure (SQL file) and creates a data model?

It doesn't have to be comprehensive at all, As long as it gives me a visual aid so I can print it and post it on my wall.

I have 30+ tables and i'll surely make a mistake if I do it manually.

If there isn't a free one, what do you recommend that's worth the dollar.

Thanks,

Dan
Jun 9 '08 #1
2 2106
r035198x
13,262 8TB
...takes a table structure (SQL file) and creates a data model?

...
Perhaps if you explain a bit about what the data model that you want should look like/contain.
Jun 11 '08 #2
dlite922
1,584 Expert 1GB
Perhaps if you explain a bit about what the data model that you want should look like/contain.
Nothing special. it does not need to make any foreign keys or any relations.

All it does is make a little square, with two rows, top row has the table name, the bottom row contains the columns.

Preferablly, and all models programs do, contains the "type" on the column and any constraints, NOT NULL, KEY, DEFAULT. etc.

I need to print this out and post it on the wall.

:D
Jun 13 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Cobb | last post by:
Hello- I'm interested in building a graphical timeline for a series of tasks that are stored in a SQL Server 2000 database. The tasks reside within a table. We also have a table to track the...
0
by: Dan F | last post by:
Folks, I find it useful for browsing to dump each table of a DB, i.e. psuedo-code like foreach table mysqldump --add-drop-table DB table > table This produces a file per table, and that...
8
by: Irvin Amoraal | last post by:
I am trying to create a CSV using mysqldump that will be viewed in MS Excel, and have a formatting question. From the command line I type: > mysqldump "--where=ent_date > \"2003-07-01\""...
1
by: Dave Crypto | last post by:
Hi there, SUMMARY: 1) When I use phpadmin to export a large database, the file created on my local PC never containes all the tables and information. It seems to max out at about 10mb. 2)...
3
by: Christopher Mouton | last post by:
We regularly make drive images of our entire server and store it at a backup site. To be honest I have never fully understood how the imaging programs deal with open files. My question is will the...
1
by: Greg.Harabedian | last post by:
I'll start off by saying I am using MySQL v4.0 and my question is...how do I get mysqldump to dump the actual binary values store in a blob? Here is an example: -- Create a test table create...
50
by: Shadow Lynx | last post by:
Consider this simple HTML: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 STRICT//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head>...
10
by: Niklas | last post by:
Hi Before I start coding I need to be sure that nobody else has not done it yet and that I can use it. I need an import utility which import data from Excel to a database or some object in...
5
by: Richard | last post by:
Hi All, I issued the command: mysqlmysqldump pmtallocmodel_development > K:/_Projects/Ruby/Backup/pmtdev_2006.07.15.txt; I got the response: ERROR 1064 (42000): You have an error in your...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.