How can we improve SQL Source Control?

Support SQL Compare Project Configuration Options

When evaluating schema for changes compared to source controlled versions is would be nice to be able to use the same options available in SQL Compare project options.

For instance changing a comment on a line already containing a comment isn't detected as a change, additionally format (whitespace) changes are not detected as well.

While this specific scenario is important to my development process not everyone will need the same scenario supported, but the compare options available in SQL Compare are a great place start allowing users control how changes are detected.

52 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    RyanRyan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    KeenerKeener shared a merged idea: Have configuration options like SQL Compare  ·   · 

    SQL Source Control v3.0.5.7 includes a mechanism to allow comparison options to be configured. To get this version, please run Check For Updates from the Help menu in SQL Source Control.

    Comparison options can now be set via a configuration file in your database repository’s Working Base folder. The following article describes how to configure this option: http://www.red-gate.com/SupportCenter/GeneralContent/knowledgebase/SQL_Source_Control/KB201202000521

    Our plan in the future is to provide an options dialog to allow users to configure the comparison options that are changed most often, but we believe this configuration file procedure should help users in the interim.

    If you’d like to see an options dialog exposing these settings in SQL Source Control, please vote on the following idea – https://redgate.uservoice.com/admin/forums/39019-sql-source-control/suggestions/2615460-add-an-options-dialog-to-allow-configuration-of-co – and let us know which options you’d like to see exposed in the dialog.

    11 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Chris SmithAdminChris Smith (Project Manager - SQL Lighthouse, Red Gate) commented  ·   ·  Flag as inappropriate

        SQL Source Control v3.0.5.7 includes a mechanism to allow comparison options to be configured. To get this version, please run Check For Updates from the Help menu in SQL Source Control.

        Comparison options can now be set via a configuration file in your database repository's Working Base folder. The following article describes how to configure this option: http://www.red-gate.com/SupportCenter/GeneralContent/knowledgebase/SQL_Source_Control/KB201202000521

        Our plan in the future is to provide an options dialog to allow users to configure the comparison options that are changed most often, but we believe this configuration file procedure should help users in the interim.

        If you'd like to see an options dialog exposing these settings in SQL Source Control, please vote on the following idea - https://redgate.uservoice.com/admin/forums/39019-sql-source-control/suggestions/2615460-add-an-options-dialog-to-allow-configuration-of-co - and let us know which options you'd like to see exposed in the dialog.

      • RyanRyan commented  ·   ·  Flag as inappropriate

        I agree with Steve, it would generally be an initial setup rather than repeated changes during a project life cycle. Glad to hear its making its way into the build.

      • StevePSteveP commented  ·   ·  Flag as inappropriate

        I would expect once its set for a project/source control link you wouldn't want to change it. So it would be an initial setup. Changing it after you've attached the DB to your Source control would result in lots of blanket commits and noise in the version control history.

      • Chris SmithAdminChris Smith (Project Manager - SQL Lighthouse, Red Gate) commented  ·   ·  Flag as inappropriate

        We plan to add support for SQL Compare comparison options via an editable configuration file initially (hopefully during Q1 2012).

        How often would you change the comparison options you use? Would occasionally updating a config file be ok for the final solution or does the frequency you change options mean that an options dialog is signifcantly preferable?

      • artimartim commented  ·   ·  Flag as inappropriate

        The other options are also important: Ignore case sensitivity, ignore default Constraint names, ignore changes to the order of creation of indexes, etc.

      • StevePSteveP commented  ·   ·  Flag as inappropriate

        Being able to exclude collations from the check in scripts is crucial. We deploy on multiple collations and have to manually find and remove all the collation statements after our commit before we build an installer. When we have the DB build itself we want it to use the default server collation not a hard coded entry.

      • Hasan AlakanHasan Alakan commented  ·   ·  Flag as inappropriate

        I agree with optional user permissions. I belive Source Control works with default SQL Compare options at the moment. It is ignoring the synonym scripts too.

      • Peter Forsberg-MadsenPeter Forsberg-Madsen commented  ·   ·  Flag as inappropriate

        In SQL compare you can chose to ignore Users’s permission and membership, with helps us deploying (user is not the same on test/dev/prod as part of the security model). We really would like to be able to have roles checked in, but without users permission. It really do not make much sense to add a filter ignoring users, but they still gets it’s permission checked in on roles and Stored Procedures.

      • BenBen commented  ·   ·  Flag as inappropriate

        I'm not sure if this comment is appropriate for this suggestion. If I should put it in a separate suggestion, let me know.

        It seems that the compare engine is the same one used in SQL Compare. If so, it would be great to have the same set of options that are provided there, or even better, if SQL Compare is installed, pull from the default options.

        In addition to the compare, it would be helpful to have an option to exclude all objects of a specific type (i.e. Users, Roles, etc)

      Feedback and Knowledge Base