Red Gate forums :: View topic - SQL Source control collatiton statements
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

SQL Source control collatiton statements

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Sergey Muraviev



Joined: 06 Jun 2011
Posts: 1

PostPosted: Mon Jun 06, 2011 2:30 pm    Post subject: SQL Source control collatiton statements Reply with quote

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
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed Jun 08, 2011 3:56 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Wed Jun 08, 2011 3:58 pm    Post subject: Reply with quote

Sergey,

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

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
lzaks



Joined: 16 Jun 2011
Posts: 2

PostPosted: Thu Jun 16, 2011 9:54 pm    Post subject: Would also like to remove collate Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Thu Jun 16, 2011 10:06 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group