SQL Compare

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

If you have any questions, need help or have found a bug in SQL Compare, please visit the forums at http://www.red-gate.com/messageboard/viewforum.php?f=154

How can we improve SQL Compare?

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.

  1. Allow preservation of custom indexes in a production destination schema when snapshot is applied

    Currently stored procs, view and tables can be excluded from a snapshot but indexes cannot as they are treated as part of a table definition.

    The problem we have is that if custom indexes are created (with an agreed naming convention) on a production DB, these are lost when a new snapshot is applied.

    I have got around this by scripting out the indexes and re-applying after the upgrade but this can take hours on large tables. It would be a great help to be able to exclude indexes (similar to tables, views etc) in the snapshot so that they…

    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  ·  Flag idea as inappropriate…  ·  Admin →
    • format comments in comparison results report

      Currently, the Comparison Results Report doesn't format comments in green, and in fact formats SQL statements inside comments as if they were active SQL statements.
      It would be best if the Comparison Results Report used the same formatting used in the Comparison Window itself, but failing that, at least comments should be clearly delineated.
      Since we use the Comparison Results Report to communicate changes for Code Review and QA, it's important to know which SQL statements are commented out and which are not.

      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  ·  Flag idea as inappropriate…  ·  Admin →
      • Save Migration scripts to SQL Source migrations

        When I create a migration script using a source control repository, I should be able to save the migration script to that repository.

        If not, in SQL Source control I should be able to import migration scripts.

        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  ·  Flag idea as inappropriate…  ·  Admin →
        • Enable the ability to compare SQL Server 2014 databases and SQL Server 2014 compressed backups.

          Support comparing SQL Server 2014 databases and SQL Server 2014 compressed backups.

          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  ·  Flag idea as inappropriate…  ·  Admin →
          • Primary key with constraint name won't replace unnamed PK

            Two tables, one with the PK defined with a "constraint" keyword and name, the other with only the name. SQL Compare only generates the create and not the corresponding drop.

            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  ·  Flag idea as inappropriate…  ·  Admin →
            • Allow Comparison of CDC Objects

              CDC (Change Data Capture) objects are currently excluded from comparison.

              Because SQL Source Control uses SQL Compare behind the scenes, this means that CDC objects cannot be committed to source control, which in turn means that databases containing objects (e.g. views) which reference CDC objects cannot be deployed with SQL CI.

              I don't believe that SQL Compare should compare CDC objects by default, but there should be an option to allow it.

              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  ·  Flag idea as inappropriate…  ·  Admin →
              • option to ignore case in schema name compare

                In version 11.1.30.30, I have 2 database where objects only differ because on schema has names that are camel cased and the other is all lowercased; everything else is identical but keeps showing in list of 'objects tat exist in both but are different'

                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  ·  Flag idea as inappropriate…  ·  Admin →
                • Add Last Used column to projects window

                  The projects window currently has columns to show the data source, date modified and project filename. Adding a "Last Used" column here would also be very useful.

                  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  ·  Flag idea as inappropriate…  ·  Admin →
                  • Allow projects to be grouped in projects window

                    In the projects window, it would be good if projects could be grouped together. For example, I have different comparison projects for things like "Local to Stage" or "Live to Local", and having to find these in the long list each time is inconvenient.

                    2 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  ·  Flag idea as inappropriate…  ·  Admin →
                    • Filter Extended Properties on other objects than databases

                      It would be great to be able to filter extended properties on other objects than databases. We only want to compare certain extended properties on tables, but the Extended Property Filter only works on database properties.

                      This is similar to this idea: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/5680027-ignore-extended-properties-created-by-the-view-des (which would be solved by filtering out "MS_DiagramPane1" on the view)

                      And suggestion #2 in this forum thread: https://forums.red-gate.com/viewtopic.php?f=177&t=77849&p=136399

                      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  ·  Flag idea as inappropriate…  ·  Admin →
                      • An 'ignore' option for differences between varchar and nvarchar datatypes

                        Provide an 'ignore' option for differences between Varchar and NVarchar data types.

                        Databases that require multi lingual support can use the NVarchar data type whereas Varchar may be used in databases that don't require multi lingual support or legacy databases.

                        Need to be able to ignore differences between Varchar and NVarchar otherwise the volume of differences returned can result in SQL Compare becoming unusable.

                        8 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  ·  Flag idea as inappropriate…  ·  Admin →
                        • Use ALTER INDEX REBUILD WITH to change FILLFACTOR

                          Use ALTER INDEX REBUILD WITH to change FILLFACTOR instead of dropping PKs, FKs, etc and reconstructing everything from scratch

                          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  ·  Flag idea as inappropriate…  ·  Admin →
                          • Change Red Gate Defaults

                            I would like to suggest that the option 'Behavior:Force Column Order' be checked by default, and the option 'Ignore:Filegroups, partition schemes and partition functions' be unchecked by default.

                            It is important to have ‘Behavior:Force Column Order’ checked, because otherwise RedGate will put any columns added during table modification at the end of the table, rather than in the same location as the source database. Similarly it is important to have ‘Ignore:Filegroups, partition schemes and partition functions’ un-checked, because otherwise RedGate will use the primary filegroup for new tables and the clustered key filegroup for new indexes on existing tables, rather…

                            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…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Ability to add additional connection parameters

                              In SQL Server management studio you have the ability to add additional connection parameters however there is no ability to be able to specify these in SQL Compare. This is a problem in SQL 2012 when trying to connect to availability group listeners that have replicas in multiple subnets. In order to connect to the availability group listener you need to specify the “MultiSubnetFailover=True” connection property, otherwise it results in a 50/50 chance of connecting successfully.

                              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  ·  Flag idea as inappropriate…  ·  Admin →
                              • Speed up comparison from a database backup.

                                Currently it is faster to manually restore a backup and then perform a comparison to using the backup file as a source. This is true for larger databases where the 'Registering Data Sources' step can take up to 40 minutes. It would be good if this process could be improved.

                                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  ·  Flag idea as inappropriate…  ·  Admin →
                                • Project Options - option to ignore parameter default values

                                  Project Options - option to ignore parameter default values. i.e. @fundid INT = 150 and @fundid INT = 152 on 2nd db is diff, option to ignore as may want to have different defaults per db but otherwise check sp.

                                  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  ·  Flag idea as inappropriate…  ·  Admin →
                                  • By allowing the thing to be updated

                                    You can't update from 10.4.8.87 to 11.1 - it says it's already installed.
                                    Which is isn't.
                                    Considering how much you charge for "support" this is pretty poor.

                                    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  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Make the Print Command on Deployment Scripts Optional

                                      Hello,
                                      We use your compare utility to deploy update's to our software. We have many many changes to our Tables/Views/Procs/etc.

                                      In each of our deployment scripts there is un-needed Print '......' & Go commands that we don't need.

                                      It would be nice to have the option of not having these print commands

                                      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  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Use currently open instance of sql server

                                        When opening a script in the editor is chosen with sql comapre it opens a new instance sql Server Management Studio even if an instance is already opened, which causes the operation to take more time than if the currently open instance was used by just opening a new tab.

                                        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  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Add a "save as" icon to the toolbar.

                                          Add a "save as" icon to the toolbar. I use this feature a lot to save a slightly different version of the current project.

                                          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  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 10 11
                                          • Don't see your idea?

                                          SQL Compare

                                          Feedback and Knowledge Base