Read triggers definition in PowerDesigner

Asked Dec 02 '14 at 14:29

Active Dec 03 '14 at 14:22

Viewed 99 times

How to read triggers definition from database when use option "Update Model from Database" in PowerDesigner 16?

This option recognizes that I have new triggers in database and read them, but Definition field is empty. Inspecting dialog box for checking changes I have to apply to model, in section Triggers I have no options available.

Can someone help me?

edited Dec 03 '14 at 14:22

pascal

3,287
1
17
35

asked Dec 02 '14 at 14:29

veljasije

6,722
12
48
79

Which DBMS are you using? – pascal Dec 02 '14 at 22:13
I am using SQL Server 2012 – veljasije Dec 03 '14 at 07:34
For SQL Server 2012, the trigger script is retrieved from sys.sql_modules.definition, which can be null if "encrypted", according to MS docs. Could it be the case? – pascal Dec 03 '14 at 13:52
No, definition is not null, I've already checked – veljasije Dec 03 '14 at 14:27
Which exact version of PowerDesigner 16 are you using? – pascal Dec 03 '14 at 15:00
PowerDesigner version 16.5 – veljasije Dec 04 '14 at 06:41

Read triggers definition in PowerDesigner

0 Answers0