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
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
- Posts: 1
- Joined: Mon Jun 06, 2011 2:26 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: 1144
- Joined: Wed Jun 16, 2010 11:10 am
- Location: My desk.
What are the main problems you get because the collation exists in your source controlled scripts?
Red Gate Software
- Posts: 1124
- Joined: Mon Dec 05, 2005 4:54 pm
- Location: Twitter: @dtabase
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 9:51 pm
Return to SQL Source Control 2
Who is online
Users browsing this forum: No registered users and 0 guests