?
Solved

How to use DBDesigner 4?

Posted on 2011-09-03
5
Medium Priority
?
521 Views
Last Modified: 2012-05-12
Hi,

       I have an existing mysql database and i want to have a diagram blueprint so it's easy to understand the database structure for anyone  who has a quick look.


How can i achieve this through DBDesginer version 4  ?
0
Comment
Question by:ee-itpro
  • 4
5 Comments
 
LVL 81

Accepted Solution

by:
arnold earned 2000 total points
ID: 36479480
Why not get mysql's native workbench and create a diagram of the database based on the existing database by connecting?

Have not used DBDesigner in a while so I do not remember on whether the same options outlined above for workbench exist/ed for dbdesigner. I.e. instead of creating the mysql DB structure from scratch whether there was an option to connect to mysql DB and load the data from there?

you could use show create database <database>
and repeat for each table.
Export the database structure/layout and import it.
http://mysqldbnews.blogspot.com/2008/06/free-database-design-tools.html
0
 

Author Comment

by:ee-itpro
ID: 36479711
Workbench not compatible with old OS so unable to install... anyhow i found a very handy  solution that doesn't even need installation :) Thanks for trying.
0
 

Author Comment

by:ee-itpro
ID: 36479727
I've requested that this question be closed as follows:

Accepted answer: 0 points for ee-itpro's comment http:/Q_27290084.html#36479711
Assisted answer: 250 points for arnold's comment http:/Q_27290084.html#36479480

for the following reason:

I knew about Workbench, however since it wasn't compatible with my old OS, i asked about DBDesigner vr. 4.x which is compatible.
0
 

Author Comment

by:ee-itpro
ID: 36479728
Please allocate all 500 points to Arnold since the solution he provided  does work, however i found something before that to help me out.
0
 

Author Closing Comment

by:ee-itpro
ID: 36493361
Thanks
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

601 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