powerdesigner导出数据库表结构
2018-09-12 本文已影响17人
yahzon
https://www.cnblogs.com/sharealex/articles/8086081.html
建立模型
以管理员身份运行PowerDesign-文件-建立新模型
![](https://img.haomeiwen.com/i6297131/22029576e68f4bb2.png)
点击OK
![](https://img.haomeiwen.com/i6297131/0030ed7281bf88c4.png)
2、配置连接
数据库-Configure Connections,点击Add DataSource
![](https://img.haomeiwen.com/i6297131/d9a93bb05a6c908d.png)
选择系统数据源,下一步
![](https://img.haomeiwen.com/i6297131/2c4f18d876a973e8.png)
选择Oracle in OraClient11g_home,点击下一步
![](https://img.haomeiwen.com/i6297131/c9291c06b132ecc3.png)
点击完成
![](https://img.haomeiwen.com/i6297131/c063e13eaff566dc.png)
配置连接参数,点击Test Connection进行测试
![](https://img.haomeiwen.com/i6297131/0190ced41fe21223.png)
输入数据库名和密码,点击OK
![](https://img.haomeiwen.com/i6297131/d4edde66e384e633.png)
出现successful的弹窗,表示数据库连接成功
![](https://img.haomeiwen.com/i6297131/3d0d8ba8abfa5f53.png)
点击OK,数据库连接配置完成
![](https://img.haomeiwen.com/i6297131/0cd8d38ae478d121.png)
此时,会多一个新建的数据库连接,点击确定
![](https://img.haomeiwen.com/i6297131/28f0021505e6d6b2.png)
3、读取数据库
数据库-Update Model from Database,选择Using a data source
![](https://img.haomeiwen.com/i6297131/fddb3296a8271ce6.png)
选择连接,输入密码,点击Connect
![](https://img.haomeiwen.com/i6297131/06eab4a3dae6e269.png)
点击确定
![](https://img.haomeiwen.com/i6297131/c9b5500ad665a62d.png)
会弹出如下界面,说明表信息已读取成功
![](https://img.haomeiwen.com/i6297131/3c5fbfb67a7cceaf.png)
4、导出表结构
可以对需要的表进行勾选,默认为全选,也可根据自己需求选择相应的表,点击OK
![](https://img.haomeiwen.com/i6297131/4c5f85bf8f60e844.png)
正在导出,请稍后
![](https://img.haomeiwen.com/i6297131/a1d3e5ec5a6935ad.png)
导出成功
![](https://img.haomeiwen.com/i6297131/1a8c50f5fbef2546.png)
将模型另存为pdm格式的文件
![](https://img.haomeiwen.com/i6297131/a4eeced41bc82dce.png)
打开PDMReader阅读器,文件-打开pdm数据字典文件
![](https://img.haomeiwen.com/i6297131/e73c268dd530131d.png)
选择做好的pdm文件,打开
![](https://img.haomeiwen.com/i6297131/d1d6abfeedf6b651.png)
展开实例项目目录,点击pdm文件
![](https://img.haomeiwen.com/i6297131/65d17e42573cf2d4.png)
将pdm导出为html或者word格式
![](https://img.haomeiwen.com/i6297131/522aec3455e42017.png)