LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-18-2012, 09:57 AM   #1
mlnm
Member
 
Registered: Jun 2011
Posts: 96

Rep: Reputation: Disabled
genarating ddl in mysql


hi, i am trying to generate ddl in mysql in a rhel server and create a database.I have a data model.
I am new to this and cant find any helpful topics about this on net.
Please guide me through procedure about how can i do that.
 
Old 01-19-2012, 12:39 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,241

Rep: Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325
Depends exactly what you mean.
If you want to generate the DDL that corresponds to an existing schema, see 'show create table' and/or mysqldump
http://stackoverflow.com/questions/1...and-sql-server
http://dev.mysql.com/doc/refman/5.1/...mysqldump.html


If you have the schema design in another format eg text, then you'll need to write a prog eg Perl to parse that to create the DDL.
Note that most (all?) schema design tools usually have a built-in fn or associated tool that will do that for you.
It may or may not be MySQL compatible if the tool is designed eg for Oracle

HTH
 
Old 01-19-2012, 09:27 AM   #3
mlnm
Member
 
Registered: Jun 2011
Posts: 96

Original Poster
Rep: Reputation: Disabled
I have my data model in visio format and i have 2007 visio but i hav read that in visio 2007 & 2010 forward engineering has been removed.And i have downloaded 2010 visio and installed a add-on for forward engineering ,but its is saying not compatible.Now what shall i do to forwaard engineer this visio file.
 
Old 01-19-2012, 06:18 PM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,241

Rep: Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325Reputation: 2325
I'm afraid I know little about MS tools, but it seems to me your first step is to extract the info into some kind of text format.
Basically you just need the table/column defns and indexes also.
Decide if you want ISAM or InnoDB engine.
Have you defined any foreign keys?

visio is all very well for diagramming relationships, but for actually specifying table/col & index definitions I know of no way to put that straight into a DB.
Its possible(??) that MS may have a tool to extract into an MSSQL schema, but as above, that may not be MySQL compatible.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
12.1 Installation doesn't recognize DVD Drive [Memorex 16x DDL-IN] Vermilion Sparrow Slackware - Installation 2 06-03-2008 12:13 AM
wine and ddl Fred Caro Linux - Software 2 01-25-2008 08:59 AM
Turtle Beach Montego DDL 5.1 not 4.1 Mig21 Linux - Hardware 1 05-30-2007 04:10 PM
DDL Soundcards slantoflight Linux - Hardware 0 09-09-2005 02:16 AM


All times are GMT -5. The time now is 06:47 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration