Export the database structure in toad to pdm and toadpdm

Export the database structure in toad to pdm and toadpdm

I. SQL statement for using toad to export the database structure:

Menu [DataBase] --- [Export] ---- [Generate Schema Script],

2. In the displayed window, the frame is checked by default. You only need to fill in the SAVE path;

3. Open powerdesigner and choose [Reverse Engineer] ---- [Database] from the menu.

4. Fill in the model name in the pop-up window and select the oracle version

5. In the next window, select the saved SQL file and click OK.

Vi. database table structure imported

7. Right-click the model name and save the file to the path to obtain the pdm file.

In addition, if you want to import the data to the doc, you can use the pdmreader tool.