PowerDesigner in SQL file, database table reverse generation PDM

1 Reverse generation of PDM

1) Create an empty PDM model (select the appropriate DBMS):

2) Select "Database"--"Update Model from Database ..." menu:

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvzhvhbmnoyw5ncwluzzkw/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/southeast ">

1.1 Using SQL Files

1) in the new form, select the appropriate Using script files--(Add files).

Then pop up the form to select the appropriate SQL file.

Click Open to complete the selection.

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvzhvhbmnoyw5ncwluzzkw/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/southeast ">

2) Click "OK" to generate.

1.2 Working with data sources

1) Select the Data source option and click "Join":

2) Select "ODBC file Data source":

3) Select NEW:

4) Next:

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvzhvhbmnoyw5ncwluzzkw/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/southeast ">

5) Select the appropriate database driver (DB2, for example). Then the next step:

6) Enter the name of the save, then next:

7) Complete:

8) Enter Usernamepassword:

9) Enter database information:

10) Confirm, then click Test:

11) and select the data source. Select the appropriate data table and click OK to generate the PDM.

PowerDesigner in SQL file, database table reverse generation PDM