powerdesigner连接oracle导出物理模型

Powerdesigner连接oracle数据库导出物理模型

一、创建数据库连接

1．创建oracle的servicename：

开始->所有程序->oracle home->配置和移植工具->Net Manage.打开oracle Net Manager

 

服务器命名->新建服务器命名

 

填写主机名

 

 

Datebase->config connection弹出Configure Data Connection

 

测试服务名

 

 

2.powerdesigner中创建数据源

创建数据源：Add Data Sourse

 

填写servicename 用户名 密码

 

二、连接数据库导出物理模型

1.逆向工程生产物理模型

File->Reverse Engineer->Database

 

 

确定

 

 

Ok

三、模型转换中文评论注释

 

Tool->Excute Command->Edit/Run Script

 

Openfile  commen2name.vbs文件：

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

 

'This routine copy name into code for each table, each column and each view

'of the current folder

Private sub ProcessFolder(folder)

 

Dim Tab 'running table

for each Tab in folder.tables

if not tab.isShortcut then

if len(tab.comment) <> 0 then

tab.name = tab.comment

end if

On Error Resume Next

Dim col 'running column

for each col in tab.columns

if len(col.comment) <>0 then

col.name =col.comment

end if

On Error Resume Next

next

end if

next

end sub