SQL Source Control

Welcome to the SQL Source Control feature suggestion list. Find out more information about SQL Source Control at http://www.red-gate.com/products/sql-development/sql-source-control/.

If you have any questions, need help or have found a bug in SQL Source Control, please review our support information http://redgatesupport.red-gate.com/home.

To get new features, performance improvements and bug fixes as soon as they’re available, you may want to turn on frequent updates: http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates

How can we improve SQL Source Control?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Commandline Source control

    It would be great if we could integrate SQL Source Control with our build scripts. For example a simple command line command to get the latest changes and apply (or script) them to our staging environment would be great. Or a command to commit all changes to source control.

    2 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      1 comment  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
    • Include sys.message custom messages in static data

      The deprecated RAISERROR, and newer THROW T-SQL instructions can use custom (user-defined) messages written into the sys.messages table using sp_addmessage.
      Since these are part of the "source" of a database in SQL Server, and should be syncronised across developers and implemented in production, it would be nice if the custom messages saved in this table can also be added to the static data in a repository.

      2 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
      • Source Control Migration Scripts - Ability to add before or after main block

        Presently a standalone migration script runs before the main block. This seems odd as the point is to migrate data and for that you need schema to be in place.

        I would like to be able to add standalone migration scripts to the end of the main block.

        We ship databases with some data populated. (This is not simple static data that can be managed using linked tables). We ship for example some out the box entities such as Roles, A base User, a base Organization etc. They have circular references so to insert we have to turn off table…

        7 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
        • Allow SQL Source Control to visualize static data potentially hidden by Row-Level Security

          While comparing static data in SQL Compare, there might occur a "red herring" issue where SQL Source Control cannot see filtered table-data due to being read by a user unprivileged for Row-Level Security. Since SQL Source Control cannot see the table-data, it will then suggest to either

          a) Fetch all table-data from the linked repository (causing all kinds of PK- and other constraint issues)
          or
          b) Commit the deletion of all table-data to the linked repository

          We don't want to do either of these actions. Although bypassing Row-Level Security for an unprivileged user isn't possible, it is still possible for…

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
          • Add a "Check Static Data" now button to the "Get Latest" tab when auto-check of static data is unselected

            We have a rather large schema with numerous static data linked...
            When I turn off the automatic check of static data, the Get Latest and commit refresh operations take only seconds!! (Awesome!)
            When i turn ON auto check of static data, it takes almost a minute (yawn!).

            It would be really great if I could have the best of both worlds... Do not automatically check static data, but manually check it as I see fit with a separate button on the GetLatest tab that says "check static data now" or something.

            4 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
            • Keeps detecting changes for value s'

              Hello,
              I have a table with only one PK column of type nvarchar(200) which contains static data.
              Source Control keeps telling that there are changes even after saving the changes. It seems that it has some issues with the value s'

              Database version:
              -- Only In Database

              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')

              -- Identical

              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan')
              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan de')

              Latest source control version:
              -- Only In Source Control

              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')
              -- Identical

              INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
              INSERT INTO [dbo].[tab_54_Voorvoegsels]…

              3 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
              • Hide columns for System Version Tables

                We are using System Versioned Tables, and on these tables SQL server adds 2 new columns SysStartTime and SysEndTime. These columns are typically marked as hidden and we need a way to ignore comparison for these. Either by a column level filter, or an option to ignore system versioning columns

                3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                • I would like to be able to pause scanning a database for changes. It is trying to do 3 at the same time with on being really.

                  I would like to be able to pause/start scanning a database for changes as will. It is trying to do several at the same time right now and one of them is huge which is taking longer than it should. If I could only scan the one I am working with at the moment it would save me time system resources.

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                  • Exporting Multiple Tables from the results pane to seperate Excel Tabs

                    The open in excel feature is impressive and I love to use it for ad-hoc extracts. Having the ability to extract multiple results in 1 go to a single Excel file with different sheets would be great.

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                    • Support unicode characters in data scripts Arabic for example

                      When linking static data to source control the unicode characters are appearing as question marks
                      so please add the support for the unicode characters in the script files

                      10 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                      • Allow a pre and post scrip to run on SQL Data Compare

                        Sometimes I need to write scripts to run before and after a SQL Data Compare.

                        9 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                        • Functionality after restore from command

                          After we have run a restore database command, the source control do not notice, that some, earlier loaded stored procedures from lastest version are after that newly out of date.
                          Source countrol should recognize a restore and scan completely new for the latest changes.

                          4 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                          • 5 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                            • Warn when adding static data tables that have foreign keys

                              When adding a static data table to source control, there should be a warning if that table has a foreign key constraint on another table and give the option to include that table as static data also. As it is the error you get in SQLCI is quite hard to decipher when SQL Source Control is used in conjuction with SQLCI.

                              4 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add Filter for Static Data Selection

                                Add a filter for static data, similar to the feature available in SQL Data Compare. This will facilitate source controlling data for tables that contain a mix of static system data and user content.

                                121 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  6 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                • Removing column does not generate update in static data

                                  If a table is setup for static data, and you remove one or more columns from that table, the static data is not updated in the working directory when "Saving changes".

                                  7 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                  • allow copy names from result Cell by Cell

                                    allow copy names from result Cell by Cell
                                    Like if we want to copy only object name it should allow.

                                    3 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Show number of rows and columns when adding static data

                                      When adding static data from a large system it would be wonderful to be able to sort on a column stating how many rows the table contains!

                                      3 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                      • some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.

                                        We have thousands of tables (some with millions of rows) with only 90-100 static data tables.

                                        At the moment, I have to edit the project; untick all then tick 90-100 manually which is very time consuming.

                                        If there was some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.

                                        Thanks for your response.

                                        Regards

                                        11 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          3 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Remove <Count> node under <DataFileSet> for static data files

                                          Currently the RedGateDatabaseInfo.xml file has a node called <DataFileSet>, underneath which is a node (<DataFile>) for each table that is static data tracked.

                                          The top node under the <DataFileSet> (before the individual <DataFile>'s) is a count of all the <DataFile> nodes below.

                                          Can this count be done in the code?

                                          I am forever solving merge conflict that are just that count node having the wrong value.

                                          6 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base