Option Explicit
Dim rowsNum
rowsNum = 0
‘————————————————- —————————-
‘Main function
‘————————————————- —–
Tag: PowerDesigner
PowerDesigner imports PowerDesigner in accordance with the Excel design data table structure
Option Explicit
Dim shet, cnt
‘————————————————- –
‘For each shet in array(“Sheet1”, “Sheet2”, “Sheet3″…)
‘————————————————- –
Dim
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
Several common modeling tools (Rose, PowerDesigner, Visio)
1, ROSE
< /span> ROSE is directly developed from UML The birth of the design tool, it appeared to support UML modeling, ROSE did not support the database-side modeling at the beginning, but the
PowerDesigner (8) – Model Document Editor (Generate Project Documentation)
The original text is from: http://www.voidcn.com/article/p-uoilqgur-oy.html
The Model Report of PowerDesigner is a model-based, project-oriented overview document. It provides a flexible and
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
Good and fake, also –PowerDesigner
[PowerDesigner]
Very good database design Tools, used before, let’s summarize today.
PowerDesigner is a powerful software capable of database design. It is a database modeling tool comm
PowerDesigner Using Tutorials (Text Tutorial)
1. Now start using PowerDesigner to create a database, first run the program and enter the main interface:
2.File—New Model—Physical Data Model—Physical Diagram—Model name< /strong> is set to
PowerDesigner use tutorial
PowerDesigner is a very powerful modeling tool software, comparable to Rose, and it is also one of the most famous modeling software today. Rose is a modeling tool that specializes in UML object mo