PowerDesigner学习

一、PowerDesigner导出数据库说明书？

1、model->reports

2、点击new

3、选择report名，语言，

ok 4、编辑你的模板，也就是要生成哪些内容，

5、在report工具栏上选择你要生成的文件格式，（rtf和html） ，还不清楚看看帮助吧。

 如果英语可以的话，应该能看懂的。

附英文说明：

1 Select ModelReports from the model diagram window.

The List of Reports appears. It displays the alphabetical list of all reports saved in the model. If there are no existing reports, all the tools in the List of Reports dialog box are grayed, except for the New Report tool and the Manage Report Templates tool.

2 Select the New Report tool.

The New Report dialog box appears. It displays a default report name.

3 Type a report name in the Report Name box if you want to modify the default name.
4 Select a language from the Language dropdown listbox. It displays the available languages. English is the default language in which the report is printed.

  For more information on languages in reports, see section Using the Report Language Editor in chapter Using the Report Editors.

5 Select a template from the Report Template dropdown listbox. The list displays the templates related to the type of the model you are working on.

or

Select None, if you do not want any particular template.

Language in a template 
When you use a template created in a language different from the one you select to create your report, only user-defined items such as Title or Text paragraph will keep the language of the template. Other items will be displayed in the report language.

6 Click OK.

The Report Editor window appears. A section is created by default at the bottom of the Report Items pane, which is filled with the template you have selected. If you did not select a template, the Report Items pane is empty. Simultaneously a report node appears under the Reports category in the Browser.

  For more information on the Report Editor, see section Using the Report Editor in chapter Using the Report Editors.

7 Build the report structure in the Report items pane.

  For more information on building a report structure, see chapter Building reports.

8 Select FileSave from the model diagram window to save your report.

 

二、PowerDesigner生成sql问题
生成sql的方法是 Database -->Generate Database (Ctrl + G ) 但是提示

Could not load VBScript engine.
Check VBScript installation.

Generation aborted due to errors detected during the verification of the model.

 

检查了好久 发现将check model 去掉就可以了！其中，

one file only是否需要按照表生成许多个sql（默认选上，即不需要）
odbc generation    sql直接生成到数据库中
Automatic archive   生成sql同时生成apm文件。

 

三、powerdesigner中怎么给一主键设为自增型auto_increment.

 在你所要设为自增型的键上（比如你的id）双击，弹出一个Column Properties对话框，右下角有一个Identify的选择框，选中它OK，就可以了。
再去查看Preview，就能看到用大写标识出来的AUTO_INCREMENT。