~~~~~~~~~~~~~~~~
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:
- open the pdm file with PowerDesigner 16.5
- go to Database->Update Model from Database...
- select "using script files" and specified a sql file (with some create index, alter table statements). pressed ok
- PowerDesigner showed progress dialog and a dialog merge models with yellow locks near some of the entities.
- 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?