SQL Source control collatiton statements

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

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

SQL Source control collatiton statements

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

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
Sergey Muraviev
 
Posts: 1
Joined: Mon Jun 06, 2011 2:26 pm

Postby james.billings » Wed Jun 08, 2011 3: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
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

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

Sergey,

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

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

Would also like to remove collate

Postby lzaks » Thu Jun 16, 2011 9: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?

Thanks,
Lev
lzaks
 
Posts: 2
Joined: Thu Jun 16, 2011 9:51 pm

Postby David Atkinson » Thu Jun 16, 2011 10: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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 1 guest