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. 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.

    1 vote
    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…)
      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
        I agree to the terms of service
        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
          I agree to the terms of service
          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
            I agree to the terms of service
            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
              I agree to the terms of service
              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

              7 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…)
                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.

                6 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…)
                  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
                    I agree to the terms of service
                    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
                      I agree to the terms of service
                      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
                        I agree to the terms of service
                        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.

                        106 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…)
                          4 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
                            I agree to the terms of service
                            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
                              I agree to the terms of service
                              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
                                I agree to the terms of service
                                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
                                  I agree to the terms of service
                                  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
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Change the icon in ssms for the tables that are linked as static data.

                                    When you link a table as static data in Sql Source control it would be nice if the static tables were easily identifiable under the tables node in management studio.

                                    25 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…)
                                      2 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Increase performance of SQL Source Control when using Static Data. Even with small amount of static data the performace is simply not accep

                                      Increase performance of SQL Source Control when using Static Data. Even with small amount of static data the performace of the tool is not acceptable.

                                      15 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…)
                                        0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Changes to data in Static Data Linked Tables should be included in the Migration Script, just as changes to the schema are.

                                        If a table is linked as static data, any changes to the data should automatically be included in the migration script, just as changes to the schema are. Having to write a manual script or use the separate compare tool is extra work, and small changes are easy to miss.

                                        39 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…)
                                          0 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Custom comparison key in SQL Source Control

                                          When adding a static table to be managed by SSC the comparison key is automatically selected. Our tables have auto generated INT ID columns as PK used in FK's. In our Static Data tables we have other columns that are unique and for them we have UK’s that we would like to use as the comparison key.

                                          Here is another with the same issue...
                                          http://www.red-gate.com/messageboard/viewtopic.php?t=16498&highlight=comparison+key

                                          I have not found any workaround for this yet at least.
                                          I believe that this would be a great improvement for SSC and would be used by many. If you agree please vote for this…

                                          69 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…)
                                            2 comments  ·  Static Data  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base