15 problems in use of powerdesigner15

Powerdesigner is mainly used for database modeling and generates the corresponding database design documents, which can be synchronized with the database.

Generally, CDM, PDM, UML modeling, and CDM can be converted to PDM.

Supports forward [database generation] and reverse engineering [database generation] and direct association to the database. PDM can be directly associated with the database and database, table, and view, trigger and other database objects are generated in the database. You can also update these objects to PDM.

Several commonly used powerdesigner menus are model, datebase, and tool. You need to be familiar with the commands used in these three menus.

PD can also be used to draw UML diagrams such as use case diagrams, sequence diagrams, and class diagrams.

You can also draw Enterprise Architecture diagrams, software application architecture diagrams, and other figures.

15 problem lists:

No. 1: Do we have to start designing CDM and then Design PDM?

No. 2: the toolbar palette is gone. How can I find it?

No. 3: How to establish association with databases?

No. 4: What are the functions of fields and data items?

No. 5: how to generate a custom growth column for the primary key, and how to operate SQL Server and Oracle Data respectively?

No. 6: How do I cancel the association between name and code?

No. 7. How do I implement the name and comment attribute interchange of fields?

No. 8: how to modify naming rules for an object, such as foreign keys, such as primary keys, and triggers?

No. 9: How to Use PD to generate test data for testing?

No. 10 how to generate the name of the Code in the script, that is, the description text of the name after the column name?

No. 11 how can I export the database structure, table name, and table fields to word, or generate an HTML file for viewing?

No. 12 how do I remove the double quotation marks when generating SQL statements? Double quotation marks can be case-sensitive in Oracle, but are abnormal and troublesome?

No. 13 How do I modify the PD display style?

No. 14 how to remove the table name and field length limit?

No. 15 how to reverse engineer the database?

Note: The PD mentioned in this article is based on the pd15. English version.

No1: Do we have to start designing CDM and then Design PDM?

I don't think it is necessary. The project size, degree of familiarity, and start-up are not the same as my habits. If you are skilled in business, it is not necessary to directly use PDM Design for small projects.

NO2: the toolbar palette is gone. How can I find it?

I found all the menus for this problem. In [tools]-[customize
Toolbars: click "open" and select "palette" in the list. In addition, you can design Alignment Methods in this window.

NO3: How to establish association with databases?

 Detailed establishment: powerdesigner establishes a connection with the database to generate the database and generate it from the database to the PD. [Oracle 10 Gb]

Powerdesigner establishes a connection with the database to generate the database and generate it from the database to the PD. [SQL Server 2005]

No4: What are the functions of fields and data items?

Fields and data items are set for reuse. data types can be consistent. For example, if many tables have longitude and latitude, two common fields can be defined ,, click model> domains]
When three fields are created, the table can be reused and the attribute of the column can be reused,If the type of the field changes, the Data Type of the column also changes.A data item works similar to this. There are also some, such as primary key incremental ID

 No. 5 how to generate a custom growth column of the primary key, SQL
How does the server and ORACLE data work?

SQL Server version:Http://www.cnblogs.com/netsql/archive/2010/05/19/1739481.html

Oracle version:Http://www.cnblogs.com/netsql/archive/2010/05/19/1739512.html

How can I cancel the association between No. 6 name and code?

Be familiar with several commonly used menus, such as model, database, tools, and report. Under tools, find General
Options ]:

No7.
How can I swap the name and comment attributes of a field?

Http://www.cnblogs.com/netsql/archive/2010/05/24/1742734.html

In addition, if you only want to automatically update the name to the comment column when generating it, perform the following operations:

No. 8:
How to modify the naming rules of an object, such as foreign keys, primary keys, and triggers?

The following uses the primary key as an example. Generally, each table has a primary key. How can I modify the definition of the primary key naming rule,

Menu: [database] -- [edit current DBMS ],:

No. 9: How to Use PD to generate test data for testing?

How to generate test data in powerdesigner

No. 10
: How to generate the name of the Code in the script, that is, the description text of the name after the column name?

Modify the field generation rule. To add a comment for each field ,:

 

No. 11:
How can I export the database structure, table name, and table fields to word, or generate an HTML file for viewing?

In this script involving the database, that is, to generate a database document for the table, it can be in HTML or DOC format .:

If you want to add more information such as data type and comment, right-click and select layout and select the information you want to display.

No. 12:
How can I remove the double quotation marks when generating SQL statements? Double quotation marks can be case-sensitive in Oracle, but are abnormal and troublesome?

When an SQL statement is generated, both the table name and field name contain double quotation marks. This requires "" to be used later in Oracle, which must be removed when a script is generated:

[Database] -- [edit current DBMS ],:

No. 13 How do I modify the PD display style?

When designing a PDM document, the style is different. Where can I set it? For example, modify the display style of a table.

[Tools] -- [display preference ],

Click the modify button to modify the table style, including the font size, color, line shape, and shadow.

No. 14 how to remove the table name and field length limit?

When a script is generated, some table names or column names are inexplicably shortened. In this case, the length is limited, which is a double-edged sword. If the tabulation name or field name must be in a certain range, this function is exactly the same, if you do not want to limit the value, you need to modify the value.

[Database] -- [edit current DBMS] -- locate script \ Objects \ table in sequence

No. 15 how to reverse engineer the database?

How to perform databases, such as Oracle and SQL
Server reverse engineering, import the database to PD