Solved

ERWin - what to use for MySQL DB script

Posted on 2003-12-01
1
1,832 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Saving Tweets with emojis using Twitter4J in a Mysql table 2 73
Insert data into database 2 35
updating table data with inner join 9 24
mcrypt_create_iv() is deprecated 4 67
A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Creating and Managing Databases with phpMyAdmin in cPanel.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

919 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now