How can we help you today? How can we help you today?

SQL Source control collatiton statements

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
0

Comments

4 comments

Sort by
  • James B
    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 B
    0
  • David Atkinson
    Sergey,

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

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • 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
    lzaks
    0
  • 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/390 ... ce-control

    David
    David Atkinson
    0

Add comment

Please sign in to leave a comment.