powerdeign把mysql生成pdm(逆向工程).docxVIP

最近因为老大要求做E/R图，所以一直在学powerdesigner(版本15.3)，感觉功能还是蛮强大的，可能是因没有用过其他建模工具吧。??今天把逆向工程的操作记录下来，因为之前在网上找了比较多的教程，走了一些弯路。?一般情况下要做逆向工程，是因为项目已经完成了，后期再来理数据模型。一般做法是先建模后开发的。下面是操作的具体步骤：1.下载mysql的odbc工具 地址：/downloads/connector/odbc//downloads/connector/odbc/?安装此功能没有什么可讲的，一直下一步即可。2. 配置powerdesigner数据库连接 先在工作空间(workspace)中新建一个物理模型(physical data model),如下图:?? 选择Database-Configure connections, ???在弹出的窗口中 “Add data source”(添加数据源)，在弹出的窗口中选择mysql odbc 5.1 deiver(此需安装mysql odbc)，选择下一步，选择保存数据源文件的名称，这个根据个人而定。?点击完成以后，会让配置相关的数据库用户名和密码，此处输入自己数据库的相关信息，如下图：至此，数据库连接已配置完成。下一步将来进行逆向工程的操作了。选择File-Reverse Engineer-Database在弹出的选择MySql 5.0如下图。点击确定出现如下图：选择刚刚新的ODBC文件。点击确定后弹出来的东西相信大家会比较熟悉了，即是自己的数据，我的是这样的，如下图。?根据自己的需求进行相应的设置，即可通过逆向工程生成相关的物理数据模型。to correcting misunderstandings advocate good cadre style. 2, to carry out the double of human activities. Bangkun will implement on the in-depth development of the grassroots, the people to worry, notification on the normalization of promoting harmony activities, making the double work innovation system, the demands of the masses reflect back channels, help enterprises to solve practical problems as much as possible. 3, visitto correcting misunderstandings advocate good cadre style. 2, to carry out the double of human activities. Bangkun will implement on the in-depth development of the grassroots, the people to worry, notification on the normalization of promoting harmony activities, making the double work innovation system, the demands of the masses reflect back channels, help enterprises to solve practical problems as much as possible. 3, visitto correcting misunderstandings advocate good cadre style. 2, to carry out the double of human activities. Bangkun will implement on the in-depth development of the grassroots, the people to worry, notification on the normalization of promoting harmony activities, making the double work innovation system, the demands of the masses reflect back channels, help enterprises to solve practical problems as much as possible. 3, visit