How to Use the PDM (Physical Data Model) of powerdesigner to generate databases and reverse engineering (to generate PDM for existing databases ))

How to Use the PDM (Physical Data Model) of powerdesigner to generate databases and reverse engineering (to generate PDM for existing databases)

After PDM is completed, it will eventually be converted into a database entity.
1. Check whether the DBMS set by powerdesigner is correct, that is, whether it is the database type we want to generate. Here I use sqlserver2000:
Powerdesigner-> database-> change the current DBMS and select your database type.

2. Configure the connection between powerdesigner and the data source
Powerdesigner-> database-> Configure connection-> User DSN (or system DSN)-> select and add your data source
3. Connection
Powerdesigner-> database-> connection-> set the DSN you just created.
OK. After the connection is set, we can generate an SQL statement for PDM.
4. Database generation
Powerdesigner-> database-> Generate database-> Configure (by default) and select OK.
Everyone knows how to execute the SQL script statement. Put it in the SQL query analyzer.