Solved

ERWin - what to use for MySQL DB script

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

791 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