Sybase PowerDesigner Change Many (Find/Replace/Convert) Data Item's Data Types
Posted
by Andy
on Stack Overflow
See other posts from Stack Overflow
or by Andy
Published on 2010-06-07T16:21:10Z
Indexed on
2010/06/08
23:52 UTC
Read the original article
Hit count: 212
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 the Physical Data Model. Ex. Change the auto conversion of Text -> Clob, to Text -> NVARCHAR(20).
Thanks!
© Stack Overflow or respective owner