Reverse Engineering in powerdesign

Powerdesginer is a commonly used database modeling tool. We do not know how to use this tool, but our group has always been using CDM-> PDM-> real dB. But there is no really waterfall development, and there are basically repeated iterations. So after we change the database structure in the development phase, you may want to reverse synchronize the changes to the design model PDM and CDM. Note:
(1) The Model files designed by powerdesginer are also inSource codeUnder the management of the manager, we hope to have a controlled version change process;
(2) conversion efficiency.
Therefore, we do not want to generate a new PDM and CDM every time we change the database structure. Fortunately, the reverse engineering capability of powerdesigner is still very powerful. The following is an example of PDM:
(1) You can choose to generate a new PDM or modify an existing PDM (which is exactly what we need .).
(2) You can select to use a script file (supporting any number of script files, but pay attention to the sequence of script files. For example, the script for creating a table must be placed before the script for creating a trigger, because PD executes the scripts in order) or ODBC data source.

If you want to use reverse engineering to update the PDM, enter the editing status of any PDM and click the following menu:

The conversion from PDM to CDM is similar, but also enters the editing state of a certain PDM first (I personally think this is a depressing point in the PD design. The conversion between models should be a common concept. No matter when I click the corresponding menu, I will provide a dialog box for setting conversion parameters, let me set the target and source. But PD is very rigid. If you want to generate CDM from PDM, You need to execute commands on the PDM operation status. The rules are clear but too strict .), Select Tools> Generate conceptual data model.