Programmer's Rules


Error "Convertion failed when converting from a character string to uniqueidentifier" while generating SQL Server database script

Solution for PowerDesigner missing keyword convertion error.

PowerDesignerSQL Server

Whe using older PowerDesigner versions (checked for 15.2) there is no newsequentialid() keyword for MS SQL Server DBMS.

The above situation causes that those, who do not have that keyword added, get as a script generation result the 'newsequentialid()' instead of newsequentialid(). It is important because the quotes are interpreted as a string not as a type.

In order to add a new keyword to PowerDesigner go to:

Database --> Edit Current DBMS --> Script --> Sql --> Keywords --> ReservedDefault

and add newsequentialid() to the keywords set.
Tutorial statistics