MySQL数据库反向生成powerdesigner模型

喜欢ヅ旅行 2022-05-20 05:07 413阅读 0赞

1.下载mysql的odbc驱动，注意下载32位的

下载地址：

[http://mirrors.163.com/mysql/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.12-win32.msi][http_mirrors.163.com_mysql_Downloads_Connector-ODBC_5.3_mysql-connector-odbc-5.3.12-win32.msi]

下载后安装即可

如果PD为64为，odbc也需要下载64位的

PD64位下载：[https://d2oa1bkv1sws6.cloudfront.net/PowerDesignerTrial/PowerDesigner16x64\_Evaluation.exe][https_d2oa1bkv1sws6.cloudfront.net_PowerDesignerTrial_PowerDesigner16x64_Evaluation.exe]

odbc64位下载：[http://mirrors.163.com/mysql/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.12-winx64.msi][http_mirrors.163.com_mysql_Downloads_Connector-ODBC_5.3_mysql-connector-odbc-5.3.12-winx64.msi]

2.配置数据源

File --> Reverse Engineer --> Database

![70][]

弹出新建物理数据库模型菜单

模型名任意填，点击确定

![70 1][]

点击 using a data source后面的 连接数据源按钮

![70 2][]

弹出窗口中点击configure

![70 3][]

弹出窗口点击新增数据源

![70 4][]

选择系统数据源，如果不可选中，也可选择用户数据源

![70 5][]

找到mysql的数据源MySQL ODBC 5.3 Unicode Driver，并选中

![70 6][]

点击完成

![70 7][]

这里进行数据库连接配置，其中填写Data Source Name后面要用到

填完之后，点击Test测试一下数据库是否能连接成功

![70 8][]

点击OK在列表可以看到已经有的数据源名称

![70 9][]

回到连接数据源窗口，下拉可以选择刚才的数据源

![70 10][]

选择aaa后点击connect ，然后点击确定

![70 11][]

弹出逆向生成菜单

![70 12][]

看上面这张图，先在All users中选择数据库名，然后点击右边的取消全选按钮，再选择要逆向生成的表，点击OK

生成之后Name一般是中文的，我们可以利用VBA脚本复制comment到Name

以下是从网上找的一段代码

代码:将Comment中的字符COPY至Name中

Option   Explicit 
    ValidationMode   =   True 
    InteractiveMode   =   im_Batch
    Dim   mdl   '   the   current   model
    '   get   the   current   active   model 
    Set   mdl   =   ActiveModel 
    If   (mdl   Is   Nothing)   Then 
          MsgBox   "There   is   no   current   Model " 
    ElseIf   Not   mdl.IsKindOf(PdPDM.cls_Model)   Then 
          MsgBox   "The   current   model   is   not   an   Physical   Data   model. " 
    Else 
          ProcessFolder   mdl 
    End   If
    Private   sub   ProcessFolder(folder) 
    On Error Resume Next
          Dim   Tab   'running     table 
          for   each   Tab   in   folder.tables 
                if   not   tab.isShortcut   then 
                      tab.name   =   tab.comment
                      Dim   col   '   running   column 
                      for   each   col   in   tab.columns 
                      if col.comment="" then
                      else
                            col.name=   col.comment 
                      end if
                      next 
                end   if 
          next
          Dim   view   'running   view 
          for   each   view   in   folder.Views 
                if   not   view.isShortcut   then 
                      view.name   =   view.comment 
                end   if 
          next
          '   go   into   the   sub-packages 
          Dim   f   '   running   folder 
          For   Each   f   In   folder.Packages 
                if   not   f.IsShortcut   then 
                      ProcessFolder   f 
                end   if 
          Next 
    end   sub

在PowerDesigner中使用方法为：

PowerDesigner->Tools->Execute Commands->Edit/Run Scripts

![70 13][]

将代码Copy进去执行就可以了，是对整个CDM或PDM进行操作

也可以将脚本保存起来，以备后续使用

原代码出处：[https://www.cnblogs.com/cxd4321/archive/2009/03/07/1405475.html][https_www.cnblogs.com_cxd4321_archive_2009_03_07_1405475.html]

常见安装报错：

1.myodbc5s.dll 找不到

解决方法：安装VC++运行库2013版

下载地址：[https://www.microsoft.com/zh-CN/download/details.aspx?id=40784][https_www.microsoft.com_zh-CN_download_details.aspx_id_40784]

推荐直接安装合集：[https://www.cr173.com/soft/62871.html][https_www.cr173.com_soft_62871.html]

[http_mirrors.163.com_mysql_Downloads_Connector-ODBC_5.3_mysql-connector-odbc-5.3.12-win32.msi]: http://mirrors.163.com/mysql/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.12-win32.msi
[https_d2oa1bkv1sws6.cloudfront.net_PowerDesignerTrial_PowerDesigner16x64_Evaluation.exe]: https://d2oa1bkv1sws6.cloudfront.net/PowerDesignerTrial/PowerDesigner16x64_Evaluation.exe
[http_mirrors.163.com_mysql_Downloads_Connector-ODBC_5.3_mysql-connector-odbc-5.3.12-winx64.msi]: http://mirrors.163.com/mysql/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.12-winx64.msi
[70]: /images/20220520/755da519833c4495b90ba1d64d04447b.png
[70 1]: /images/20220520/d869a15c984f448c8ad8cf2fa80695a0.png
[70 2]: /images/20220520/b82540392378420a9a3f727387d9da68.png
[70 3]: /images/20220520/1a58c75663f7465d8d9ce4eec6b18fd7.png
[70 4]: /images/20220520/92178acb598347aab6f039ba270b56d9.png
[70 5]: /images/20220520/6e1f99114567464e892e01d75a580946.png
[70 6]: /images/20220520/fb052f0f4f5c4e5498838b3efd3a44dc.png
[70 7]: /images/20220520/38e5b827b7c14363a3ddf5d55b01e957.png
[70 8]: /images/20220520/1ef618a4b1e54999aae3933723ac4b86.png
[70 9]: /images/20220520/7e949ce7ada8496a8c3709511b0358aa.png
[70 10]: /images/20220520/19e355cb02ea4d46a0358417f17308ad.png
[70 11]: /images/20220520/73c8684d2d5f494cbaabd8bb6b93530b.png
[70 12]: /images/20220520/c1daffe1b0e142298f8c8d7b9a9e1dc5.png
[70 13]: /images/20220520/dcab2dc9480242c288555605be763627.png
[https_www.cnblogs.com_cxd4321_archive_2009_03_07_1405475.html]: https://www.cnblogs.com/cxd4321/archive/2009/03/07/1405475.html
[https_www.microsoft.com_zh-CN_download_details.aspx_id_40784]: https://www.microsoft.com/zh-CN/download/details.aspx?id=40784
[https_www.cr173.com_soft_62871.html]: https://www.cr173.com/soft/62871.html