power designer pdm生成sql脚本和数据库
今天使用PowerDesigner生成数据库脚本和直接生成数据库。所以简短的记一下。
![](https://images0.cnblogs.com/blog/681761/201505/260112181937941.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112235687616.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112270844692.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112377243542.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112434909802.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112444123717.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112446935503.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112453498104.png)
1,老师给的pdm文件,打开如下(可以理解为概念数据模型)
![](https://images0.cnblogs.com/blog/681761/201505/260112181937941.png)
2 , 将“概念数据模型”设计的表转换为“物理数据模型”(Physical Data Model),实际上是从“概要设计”转换为“详细设计”,即对表的具体实现。将概要设计模板转换为物理设计
选择“Tools”-->“Generate Physical Data Model…”即可。选择自己DBMS。
![](https://images0.cnblogs.com/blog/681761/201505/260112235687616.png)
步骤如下:
a.选择“Datebase”-->“configure connections....”弹出如下窗口
![](https://images0.cnblogs.com/blog/681761/201505/260112270844692.png)
b.选择
(创建一个新的ODBC链接),选择“系统数据源”,然后选择自己刚才创建DBMS
![](https://images0.cnblogs.com/blog/681761/201505/260112300068950.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112377243542.png)
c.单击下一步后填写如下信息
![](https://images0.cnblogs.com/blog/681761/201505/260112434909802.png)
d.完成后单击
“测试”按钮,如图
![](https://images0.cnblogs.com/blog/681761/201505/260112437404346.png)
![](https://images0.cnblogs.com/blog/681761/201505/260112444123717.png)
显示测试成功。
![](https://images0.cnblogs.com/blog/681761/201505/260112446935503.png)
4,下面开始生成数据库。
a.选择"Database"-->"Generate Database...",显示如图,单击“确定”即可!
![](https://images0.cnblogs.com/blog/681761/201505/260112453498104.png)