Convert PDM to MYSQl Databases in powerdesigner
Use PowerDesigner to design and build a MySQL database
1. Create a database creation script using PowerDesigner
1. Design CDM (Conceptual Data Model)
2. Select Tools> Generate Physical Data Model, select the corresponding DBMS as MySQL, and Generate PDM
3. Select Database-> Generate Database. In the pop-up Database Generation dialog box, select the script access path and script file name.
4. Click OK to generate the database creation script (*. SQL)
You can run the SQL script in either of the following ways:
Method 1:
In the command line (Database not connected), enter mysql-h localhost-u root-p123456 <F:/mytest/testdb. SQL (note that no quotation marks are required for the path !!) Press enter.
Method 2:
Enter source F:/mytest/testdb. SQL in the command line (the database is connected, and the prompt is mysql>) and press Enter.