Solved

ERWin - what to use for MySQL DB script

Posted on 2003-12-01
1
1,834 Views
Last Modified: 2008-02-01
I have a MySQL database that I am designing in ERWin. I would like to use the ForwardEngineer option but unfortunately MySQL is not supported as a database type for the physical model.

Of the following db types, which would require the least amount of corrections to the DDL script file in order to generate a MySQL database? (which is the closest to MySQL?)

AS/400
DB2
ingres
Oracle
SAS
teradata
Interbase
PROGRESS
SQL Server
HiRDB
INFORMIX
Rdb
SQLBase
Sybase
Red Brick

...and what are the slight differences I would need to change?

Thanks!



0
Comment
Question by:illucid
1 Comment
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 250 total points
ID: 9887823
Hi illucid,

i'd suggest sql server....

each time you discover a mismatch you can then tailor erwin via it macros...
etc i believe to rectify the syntax....

not used erwin for a while....
 

Cheers!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL inner join confusion 15 53
simple shopping cart database structure 5 46
PHP: concatenate query 13 69
Mysql Left Join Case 10 56
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

832 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