How to introduce changes in pdm with sql script via PowerDesigner

2.6k Views Asked by At

~~~~~~~~~~~~~~~~

Hi, all! I have a database model xxx.pdm and a sql script I want to apply to the db (so that generated xxx_db.sql, xxx_triggers.sql, etc will contain the changes - the files are used in whole application building process to generate yyy.db file).

I've tried to:

  1. open the pdm file with PowerDesigner 16.5
  2. go to Database->Update Model from Database...
  3. select "using script files" and specified a sql file (with some create index, alter table statements). pressed ok
  4. PowerDesigner showed progress dialog and a dialog merge models with yellow locks near some of the entities.
  5. I try to generate database: Database->Generate database... in the dialog xxx_db.sql is selected.

the result - generation aborted due to errors detected during the verification of the model.

Category    Check           Object                      Location
Reference   Incomplete join Reference 'FK_table1_col1'  <Model>
Reference   Incomplete join Reference 'FK_table2_col2'  <Model>

at the same time the sql script is well executed via Sybase Interactive (cmd line).

Is my approach correct? Maybe I'm doing something wrong?

0

There are 0 best solutions below