SQL Source control collatiton statements

[Sergey Muraviev]

Dear, all.

Could you please clarify how to remove collation statements from scripts when commiting changes in SQL source control?

Sample:
[Name] [nvarchar] (255) COLLATE Cyrillic_General_CI_A

[james.billings]

Currently there's not a way to alter the script at commit time. The object is effectively committed "as-is".

SQL Compare does have an option to ignore collations during the compare and sync stages, and there is a request under consideration to include the same options SQL Compare offers within SQL Source Control. You can add your vote, and comments, here

[David Atkinson]

Sergey,

What are the main problems you get because the collation exists in your source controlled scripts?

David Atkinson
Red Gate Software

[lzaks]

I can't speak for Segrey, but I don't want the collates added in case I need to create the tables on a different database with a different collate default setup. This is why I didn't include the collate in the intial table creation.

Is this feature going to be added to the product? If so, when?

Thanks,
Lev

[David Atkinson]

This feature will be added to the product at some point. However, it's not possible at this stage to determine its backlog priority. Please vote it up on our UserVoice site.

http://redgate.uservoice.com/forums/39019-sql-source-control

David