SQL Source control collatiton statements

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

SQL Source control collatiton statements

Postby Sergey Muraviev » Mon Jun 06, 2011 1:30 pm

Dear, all.

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

[Name] [nvarchar] (255) COLLATE Cyrillic_General_CI_A
Sergey Muraviev
Posts: 1
Joined: Mon Jun 06, 2011 1:26 pm

Postby james.billings » Wed Jun 08, 2011 2:56 pm

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
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Postby David Atkinson » Wed Jun 08, 2011 2:58 pm


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

David Atkinson
Red Gate Software
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Would also like to remove collate

Postby lzaks » Thu Jun 16, 2011 8:54 pm

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?

Posts: 2
Joined: Thu Jun 16, 2011 8:51 pm

Postby David Atkinson » Thu Jun 16, 2011 9:06 pm

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/390 ... ce-control

David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests