1. Install PowerDesigner Reference
https://blog.csdn. net/sinat_34104446/article/details/79885141
com.mysql.jdbc.Driver
jdbc:mysql://192.168.0.151:3306/nbspider Test connection to P
Tag: generated
PowerDesigner generates an Excel version of the database file
To convert the database design to an excel version, Baidu will publish a script file, which is easy to use and find out, keep a memorial
In pd, shift+ctrl+X, open the script to run, the scrip
SQL file in PowerDesigner, database table reverse generation PDM
1 Reverse PDM generation 1) Create an empty PDM model (select the corresponding DBMS) :
2) Select [Database]–[Update Model from Database…] menu:
1) In the new window, select the cor
PowerDesigner generates automatic identification of mysql statements, Name, and comments
When using PowerDesigner to design the ORACLE library table in the past, it is very convenient to generate the SQL statement to build the table. There is an option, which means that when the COMMEN
PowerDesigner (8) – Object-oriented model (with example diagram, sequence diagram, class diagram, generating Java source code and Java source code generation class)
http://blog.csdn.net/conviction_thinking/article/details/7959270
PowerDesigner generates data structural diagrams and corresponding SQL export methods
1. Download powerDesigner
The link address is http://soft.onlinedown.net/soft/577763.htm
2. Open the software, file -> new project, create a new project; then create a new entity to bui
PowerDesigner (5) – Concept Data Model (CDM Generate LDM, PDM and OOM)
The original text is from: http://www.voidcn.com/article/p-avzfndrz-oy.html
Conceptual Data Model (CDM): expresses the overall logical structure of data, which is independent of any software
PowerDesigner appears in the process of generating a script appears on a Constraint Name Uniqueness Reference solution
An error occurred as shown below:
The reason for the problem: the constraint name was repeated during the script generation process
Solution:
1. Double-click error
2. Select Integrity
4. Modify the constraint name in Constraint name Save the name and confirm
Automatically generates annotations when PowerDesigner exports SQL
Reproduced:
powerdesigner16 is also applicable
Create a new Physical Data Model in powerBuilder, and create a new user table in it. The information is as shown in the figure below:
<
PowerDesigner generated Oracle built-in script to remove the quotation number of lowercase objects
This time I used pd to design the database. I didn’t pay attention at first. All table names and field names are in lowercase letters. As a result, all the objects in the generated script were quot