PDA

View Full Version : MySQL VS ER digram !



ccsi
May 11th, 2011, 04:55 PM
hi every one here

I installed DBDesigner4 from here
http://www.fabforce.net/downloadfile.php

and i did all instruction until i got this on my terminal

user@ubuntu:~/Downloads/DBDesigner4$ ./startdbd
Create symbolic links in /home/user/Downloads/DBDesigner4/./Linuxlib ...
/home/user/Downloads/DBDesigner4
Starting DBDesigner4 ...
user@ubuntu:~/Downloads/DBDesigner4$

< i think i run it correctly.

my question is as follow:
I have sql file got it from extracting it from PhP MyAdmin whrer I used it to creat my DB, I am trying to use tool which converts .sql file to entity relational digram (( ER digram )Automatically . i found many pages suggested DBDesigner4 , I really installed it . but still did not Know how ?
or if there are any suggested tool , it will be welcome?

would you main please to guide me ? it will much appreciated

sanderd17
May 11th, 2011, 05:20 PM
For ER to SQL, you can use this: http://er2sql.sourceforge.net/

For the other way around, maybe use this: http://snowflakejoins.com/revj/index

I hope it helps.

ccsi
May 11th, 2011, 10:54 PM
thank you for your response

I tried the second link to convert my sql file with tables to ER but i got stuck ...

are you sure that it is convert mysql to ER ?