views:

327

answers:

1

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 Uppercase. Actually, I am not getting any error message or anything like that and I'm actually allowed to type in a mixed case database name but as soon as I close the "Model Properties" window and come back to it to check, the database code name is back to Uppercase.

I obviously unticked the = button connecting the logic name to the code name so I can type a code name different from the code name but it still doesn't work (while it does for tables).

Is there any way to have a database name in the generated SQL script corresponding to the case I specified in PowerDesigner? The DBMS type is SQL Server 2008 (tried previous versions and the problem is the same).

Thanks a lot in advance.

+1  A: 

Nevermind, I found how to do it: right clicking on an empty spot in the work space then selecting Modem Options from the menu and then under naming convention -> Code tab.

Thanks anyway.