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.1 Use SQL files

1) In the new window, select the corresponding [Using script files]–[(Add Files)]. Then pop up a window to select the corresponding SQL file. Click Open to complete the selection.

2) Click [OK] to generate.

1.2 Use Data source

1) Select the data source option, and click [Add]:

2) Select [ODBC file data source]:

3) Choose New:

4) Next step:

5) Select the corresponding database driver (here, take DB2 as an example), and then the next step:

< p style="margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; font-family:Arial; font-size:14px; line-height:26px">

6) Enter the saved name, and then the next step:

7) Complete:

8) Enter username and password:

9) Enter database information:

10) Confirm the completion, and then click Test:

11) Then select the data source, select the corresponding data table, and click OK to generate PDM.

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 816 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.