In PowerDesigner v12, how would one, through use of VBScript, assign a TriggerTemplate to triggers that are missing the definition? We have a script now that can loop through the triggers and display the triggertemplate (if it has one), but all attempts to assign a template to these triggers have failed. Any insight would be greatly ap...
Hi, I am currently beginning playing around with PowerDesigner and its logical data model (PDM). I have managed to create some entities/tables, columns, etc fine and the case in the generated SQL (to create the database from the model) is like I want. However, regarding the database name, PowerDesigner insists for it to be always in Up...
I'm doing a conceptual model in Sybase PowerDesigner. The restriction is following: One doctor can work in only one office at a time during his working time (shift). I guess Doctor - Office relationship should be many-many, but what about time restriction ("during his working time")? Should it be a new table SHIFT? So I guess I shoul...
I've installed PowerDesigner 15.1 on my machine, and plan to use its AddIn for VS.NET. But it causes the solution file (SLN) to be modified everytime I build, run, debug, or close the solution. And the VS doesn't change ANYTHING in the SLN file. (A compare to the history results in the message saying that the files are identical) This e...
How to create generics in PowerDesigner (ver10)? Is there some good tutorial for PD? ...
Hi. Can you suggest me some book or tutorial for Sybase's PowerDesigner? Thank you ...
I just want to create the model once, and then use it in any kind of database, without the need to modify the model. What I should do with the data type ? I found there is numeric and other kind of data types. What does that correspond to in mysql or access ? ...
I want to rename columns in a PowerDesigner LDM/PDM according to the state of the Primary checkbox. To be more specific, I want the column renamed from "oldname" to "id_oldname" if Primary is checked. I think it is possible with a custom check/autofix script like the one in "MSSQLSRV2008::Profile\Column\Custom Checks\Identity Seed and I...
Hello, I have a relatively large Conceptual Data Model in PowerDesigner. After generating a Physical Data Model and seeing the DBMS data types, I need to update all of data types(NUMBER/TEXT) for each data item. I'd like to either do a find/replace within the Conceptual Data Model or somehow map to different data types when creating t...
Is there a simple way to make Powerdesigner generate an XSD file? It generates an XSM file, but it's not the same specification. If there were a simple way of doing it, it would ease my life as heaven :P. ...