power designer几个技术

1. from sql file to pdm 根据sql文件导出pdm
菜单file->Reverse Engineer ->Database
选择 DBMS点击确定
选中using script files 点击Add files按钮添加sql文件。然后点击确定。

2. from pdm to cdm从pdm生成cdm
菜单tools->Generate Conceptual Data Model

3. from cdm to pdm从cdm生成pdm
菜单tools->Generate Physical Data Model

3. from pdm to rtf从pdm生成rtf文件(为了文档需要,如word表格)
1)在左侧Workspace下的PhysicalDataModel_1上右键单击->new->Report
2)弹出的窗口中选择语言English或Simplified Chinese等等。
3)窗口分成了两栏。左侧Available items中列出了许多条目。双击某条目可以选到右侧。比如选择List of tables和Table下面List of table columns
4)右侧是已经选择的项。在某项上右键单击selection选择需要使用的列。点击Ok。
5)在某项上点击右键Layout选择需要显示的内容,设置宽度。
6)左侧Workspace下PhysicalDataModel_1里面有Reports,选择需要的Report(当前可能为Report1),右键Generate->RTF

4. 打开Paletee窗口:工具栏空白处右键->paletee。同样方法可以打开左侧Browser或其它窗口。

This entry was posted in Computer, Database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s