UPPERCASE??

[nacmorn]

Hello,
I have just found out that when the application creates a new table it always makes lowercase the column name....is there any way to make the application write this column name in uppercase directly??

Thanks.

[.jp]

Hello,

Thanks for the post.

I've just tried to create a new table in a visual table editor of dbForge Studio for SQL Server Professional Edition : named columns like column1 and COLUMN2 and saved the table. Columns were saved as I named them: column1 and COLUMN2.

So, could you please answer the following question:
1) What's the product you are using (edition and version)?
2) Where did you create a new table (visual table editor or sql document)?
3) What's the version of your SQL Server (SQL Server 2000, 2005, 2008, 2012)?

Best Regards.

[nacmorn]

Hello,

1) dbForge Schema Compare for SQL Server Professional Edition Version 3.0.62
2) SQL Script and synchronization script in the internal editor
3) Source: SQL Server 2005 SP4 --> column name uppercase
Target: SQL server 2008 R2 SP2

In source the column name is uppercase but it converts lowercase in the schema update script.


Thanks.

[alexa]

Please check whether the 'Ignore case' option is selected or not on the 'Options' page of the New Schema Comparison wizard.