Devart Forums

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.

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.

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.

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