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 https://forums.red-gate.com/viewforum.php?f=200

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

    Allow the "Group by" dropdown selection to be saved with the project. When I open a project, it's always set to "Type of difference". I prefer "Type of object" most of the time, and would like my projects to open that way.

    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 →
    • Add optional search box on the opening screen

      Sometimes I go into SQL Compare and I'm really just interested in one stored proc or table. Would it be possible to run Compare much more quickly if it only pulled in those items that one is searching for? Currently it pulls in and compares all database items, which can take some time. If it only had to pull in a handful of items I'm assuming it would launch very quickly.

      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…)
        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
      • Make it possible to use migration scripts when doing a database to database deploy.

        It worked before and it should be up to me to decide, not the program.
        And since source control to database deploy always crashes I have no other way to deploy.

        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 →

          I’m afraid the design of the new migration scripts does not allow them to be used during database to database comparison, because the migration scripts are never actually stored in the database – they only exist in the ‘Custom Scripts’ sub-folder of the Scripts Folder.

          However, source-control to database deployment should not crash – I’ll contact you personally to find out a bit more about what’s going on there – we should be able to resolve the problem for you.

          Please feel free to continue voting for this feature if it’s important to you – we use Uservoice votes to guide our future development priorities.

          Mike Upton
          (Technical Lead – SQL Source Control)

        • dark theme

          You should create a dark theme (gray or black) UI for us who are constantly staring at your interface...

          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 →
          • New Option to Ignore Statistics_Incremental

            I would love to have the option to ignore the Statistics_Incremental setting on indexes much the way "Ignore Statistics_NoRecompute" works. I currently have two DBs - one has this option on all indexes and one has it on none. Currently SQL Compare flags all indexes as different even with "Ignore Statistics" turned on. The only option is to ignore Indexes entirely which isn't practical because those are the most frequently changing objects between the DBs. I'm currently still using SQL Compare 10 because it does not pick up the Statistics_Incremental option but I would love to be able to upgrade…

            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 →
            • With Values

              When deploying a table change which contains a new column (which has a default specified) I would appreciate the ability to have the "WITH VALUES" added automatically to chosen columns.

              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 →
              • index table variables

                SQL Compare should raise warnings when it is generating a deployment script which contains features that are not available in the version of the destination server. For example, indexes on table variables are available only in SQL Server 2014 or later.

                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…)
                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                • SQL Compare UI - Project Options: Add the related command line option/switch to the description of each option/checkbox

                  It would make it easier find the related cmd line options (that correspond to same selections done in SQL Compare UI - Project Options) if the descriptions would contain also the command line option syntax or even example. (And by description I mean the mouseover texts that is shown on right side in project options when mouse is hovered over the checkbox/text.)

                  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  ·  Flag idea as inappropriate…  ·  Admin →
                  • generate SSDT compatible script folders from the command line

                    Using the GUI there is a "Database Project Compatible" option for generating a script folder. Based on the thread below, there is no way to do this from the command line. Adding this functionality would be helpful for automation.

                    https://forums.red-gate.com/viewtopic.php?f=200&t=80400&p=144144#p144144

                    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 →
                    • Convert to WebApp / Service

                      Convert the the desktop app to a WebUI. running a core server infrastructure makes running little desktop apps like this an unwanted overhead.

                      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 →
                      • Similar to other ideas, any project option to ignore should give ability not to display ignored option finds in comparison result

                        The project option gives you the ability to ignore based on certain filters e.g. white space. However, if any other difference is found, when you display the comparison it highlights the things you told it to ignore. If in the case of white space, every line shows a highlighted difference for a white space difference, but the one actual difference you are looking for is impossible to find without scanning the whole comparison. Ignore should give you the ability to ignore in the comparison view also (for any ignore project option).

                        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…)
                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                        • SSIS package compare

                          I would like to suggest that SQL compare tool also have to support SSIS package compare. Currently I am at the position that I have to compare SSIS packages between two servers and find out if any SSIS packages missing plus if any SSIS packages on old version etc. Currently I am talking about SSIS packages reside in MSDB but even if it can be compare between file system, that will 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…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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 →
                            • Allow me to change my liscense number

                              Allow me to change my liscense number

                              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 →
                              • Scripting Identical Objects

                                I am in the middle of merging two databases and it would be of great help to script identical objects as well.

                                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 domain users and SQL users not equal even if they have the same name (except for domain name)

                                  Before SQL Compare v12, domain users and SQL users were treated as two seperate objects when they had the same name (except the domain name).
                                  E.g. "CONTOSO\john" <> "john"
                                  Now in v12, these two logins are considered equal. This is apparently by design.
                                  I would like an option to compare these as the two different logins they actually are.

                                  13 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  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Choose a subset of views or stored procedures.

                                    I work on a purchased package that has many thousands of objects. We added 150 custom views which all all begin with "v_", such as v_projects.
                                    Let me compare just my views, and ignore the 2000 vendor views.

                                    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…)
                                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Ignore Tabs

                                      White space option is ticked but it's still highlighting differences with tabs at the beginning of the line

                                      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 →
                                      • Command line: create target database

                                        The SQL Compare GUI provides the option to create a target database if it doesn't already exist. Please provide a corresponding command line option so that DLM Automation packages can create a deployment target without requiring run-once, handcrafted Powershell scripts.

                                        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 →
                                        • BUG - Invalid script generated when Unbinding Defaults from columns

                                          If some column has a default bound to it, and it is then removed, the script generated by latest version of SQLCompare12 is invalid.

                                          See result script below. The related default is [dbo].[CM_Zero], but in the script the comparison of 'default_object_id' the schema part gets duplicated and there will be too many brackets...

                                          ...
                                          PRINT N'Unbinding defaults from columns'
                                          GO
                                          IF @@ERROR <> 0 SET NOEXEC ON
                                          GO
                                          IF EXISTS (SELECT 1 FROM sys.columns WHERE name = N'Type' AND object_id = OBJECT_ID(N'[dbo].[tblCMDefinition]', 'U') AND default_object_id = OBJECT_ID(N'[dbo].[[dbo]].[CM_Zero]]]', 'D'))
                                          EXEC sp_unbindefault N'[dbo].[tblCMDefinition].[Type]'
                                          GO
                                          ...

                                          I confirmed that this error is coming…

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

                                          SQL Compare

                                          Feedback and Knowledge Base