Skip to Content

PowerDesigner Reverse Engineering from a Script - tables dropped after creating still in model

I've built a MySQL v5.0 PDM in PowerDesigner (16.1) by reverse-engineering a script. This worked OK, or so I thought. The SQL script contains several drop table statements, i.e. it creates these tables and then drops them later. These tables dropped in the script have made it through to the PDM, so there is a discrepancy.

I don't have any control over this script, so I can't even remove the create table statements (so these tables are never created). I'd have to take a copy of the script and edit that before trying to reverse engineer it, which I'd rather not do.

Haven't encountered this before, so not sure if this is the expected behaviour. Can I do anything in PD to get to the correct numbers of tables from this script, or do I need to just update the model and manually remove these tables post reverse-engineering?

Thanks, Antony

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 26 at 08:47 AM

    I am not sure about this (someone from SAP should confirm it), but I think, that this is not a bug, but a "feature". PD is IMHO skipping all drop statements.

    Ondrej

    Add comment
    10|10000 characters needed characters exceeded