PowerDesigner can reverse engineer a PDM for one or more SQL script files. The script will normally be the script used to generate the database but can also include other scripts.
or
To reverse engineer a script and create a new PDM, select File > Reverse Engineer > Database to open the New Physical Data Model dialog. Specify a model name, choose a DBMS from the list, and then click OK.
or
When working with the PowerDesigner Eclipse plug-in, select any SQL file in the Navigator, right-click it and select Reverse Engineer from SQL File. You are given the option to reverse into an existing or new PDM.
The following tools are provided to help with script selection:
If you are reverse engineering to an existing PDM, then the Merge Models dialog box opens to allow you to control the merging of the new objects into your PDM (see Core Features Guide > The PowerDesigner Interface > Comparing and Merging Models). When the process is complete, a confirmation message is given in the Output window.