Erwin is a commonly used tool for database design, supporting numerous databases, but unfortunately do not support mysql, it is probably because few companies use MySQL, but MySQL is actually very excellent. In order to be able to use Erwin's physical design based on the MySQL database, the following method steps can be employed: 1. Install MySQL ODBC Driver, you can go to mysql.com, there is a link to download. 2. Create a USER / SYS DSN that connects your MySQL database in the ODBC's hypervisor. 3. Create a new PhysicalM Model based on ODBC 2.0. I don't know what the logical, physical, logical / physical model is there. Logical and Logical / Physical Model don't have a menu for Schema Generation (although you can export, you can't change the database). However, Physical Model has a limit, that is, it cannot generate BPWIN. Tools: ER4.0 SP1, Build 1511, crack version. 4. This step is the focus: because ODBC-generated database scripts are not fully compatible with MySQL SQL syntax, there is still some other work. For example, sometimes you need to use DateTime Type, but you can only generate Date Type, we can use the SQL script to complete, Erwin supported scripts: Model-Level, Table-Level. The former is the entire Physical Model, while the latter Can be used for 1 or more TABLE. According to the order of operation, it is divided into two types: pre-script, post script. I don't know the name. If we want to set the "create_on" Type in the table to DateTime, you can generate a table-level script: ALTER TABLE% TABLENAME MODIFY CREATE_ON DATETIME% TABLENAME is the macro itself with Erwin, and there are many other macros, about this You can help it. You can also define different scripts according to your own needs (for example, set a field for auto_increment). In the Forward Engineer, PRE Script, Post Script, and then generate according to the actual situation. [Ref: http://erwin.softwarechn.com/_script/show.asp? Board = Skill & ID = 75 & TabName = erw] This can be used here, for example, to generate a DateTime type, if you enter DateTime directly, it will automatically convert to Date You can enter space DateTime. This has no effect on the generated SQL, eliminating the trouble of making Script. 4.SQL Preview: The generated mysql data table:
