PowerDesigner通过SQL文件，反向生成模型

一、使用mysql文件进行逆向工程生成模型

1、File > Reverse Engineer > Database... （选择需要的SQL库表脚本定义文件）
2、Tools > Execute Commands > Edit/Run Script... (复制下面的脚本)在第一次时可能会用到

二、导出图片或svg文件

1、在模型中选中需要导出的内容；
2、在上方的菜单栏中点击“编辑”；
3、在展开的菜单栏中点击“导出图像”，选择导出的图片保存类型，填写文件名，点击“保存...

三、逆向工程可能用到的脚本

Option Explicit 
    ValidationMode = True 
    InteractiveMode = im_Batch
    Dim blankStr
    blankStr = Space(1)
    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 = "" or replace(col.comment," ", "")="" Then
                            col.name = blankStr
                            blankStr = blankStr & Space(1)
                      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

十、参考

[1] PowerDesigner根据SQL文件反向生成物理模型（MySql篇） https://blog.csdn.net/liyanxia_cs_dn/article/details/84793733