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. Launch SQL data compare from within SQL compare

    A time saver for me would be to Launch SQL data compare from within SQL compare and pass the source and target along for convenience.

    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 →
    • Do not highlight changes which I want to ignore (e.g. square brackets)

      The problem is when you want to ignore and don't see differences due to brackets and you want to ignore them
      (the option "Ignore square brackets in object names")
      Currently, it works like below:
      a) with "Ignore square brackets in object names" checked:
      https://redgatesupport.zendesk.com/attachments/token/0ay3ukHEONcTW6JJsnbRgnHZE/?name=inline-1914004586.png

      b) with "Ignore square brackets in object names" cleared:
      https://redgatesupport.zendesk.com/attachments/token/icPFTLJoEsZUh2HGvv1GKXevm/?name=inline224740133.png

      So, in the first scenario (when "Ignore square brackets in object names" checked) I would suspect:
      1) Objects equals (achieved - good)
      2) No highlighted differences in bottom comparison window (which happens currently - incorrect)
      It inconsistent behaviour - when objects are identical - there should…

      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 →
      • Skip/Ignore comparing a certificate if the user does not have access

        When performing a SQL compare on a database, if the user does not have access to a certificate, the compare fails with an exception.

        The proposed solution would see SQL Compare skip the compare if it cannot access it, behaving similar to encrypted stored procedures.

        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 →
        • Ignore system-generated constraint names in deploy script

          Right now, generated deploy scripts include the system-generated constraint name in drop statements, regardless of whether the option to ignore system-generated constraint names is selected.

          This causes problems when attempting to deploy the same changes to a third database that was generated from scripts.

          It would be nice to be able to generate scripts that work out of the box in the bulk deploy scenario also, instead of requiring manual intervention to generalize the script.

          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 →
          • Copy to clipboard bug

            Please fix the copy to clipboard function(s), for petes sake, this has been a problem since, at least, version 4. I see others have a varying range of issue with the clipboard. It's not that hard to fix over 10 years+, surely!

            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 →
            • When comparing sequences, should be able to ignore the START WITH value

              When comparing sequences, ANY difference triggers the program to indicate a difference. In reality, when it comes to sequences, the START WITH value changes with use. If two environments are being compared and one is used for different testing, or even as a production environment, the START WITH value will likely be different. This doesn’t mean the sequences are different and, in fact, can lead to serious problems for objects that rely on the next value in the sequence being unique. There should be a way to ignore the START WITH value when comparing sequences.

              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 →
              • Please revert to the output report side by side view as previous.

                Hi, I would prefer the old side by side view - new is just too difficult to understand.

                12 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 Drops Index But Does Not Add Back When Editing Computed Column

                  If you have an index on a table that includes a computed column, alter the column then run the compare, the compare script drops the index so the column can be dropped and added back with the modifications. However the script never adds the index back and I have to rerun the compare after applying the change script to get the index added back.

                  Sounds like a bug? Unless I am missing an odd setting somewhere.

                  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 →
                  • Generate button is grayed out. Can't generate reports in the newer version.

                    The Generate button is grayed out in version 13. Can't generate compare reports.

                    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 →
                    • delete "my projects"

                      Add a menu to remove physical file on disk from the "My projects" dialog

                      I always use the My projects dialog to load my project and often I got same project with different file extention (sdc, scp) or different name, when i find a duplicate I want to keep only one copy and delete the other.
                      I old version (11) they was a menu "Locate file on disk" that I use to locate the file in Explorer and I delete it. Now this feature was removed and I have to manually find the file, my filename are a mess because…

                      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 →
                      • Add option for older version of HTML Report in SQL Compare 13

                        The new version of the HTML report is not as useful as side-by-side comparsions. I don't like the new version, and the developers like it even less. Thanks!

                        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…)
                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                        • Change the icon of SQL Compare and Data Compare. Too similar!

                          I know you want to keep them red but changing the design would help the eyes.

                          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 →
                          • Multi-Database schema report

                            I want the ability to compare multiple databases either synchronously or asynchronously to a baseline. I'm looking at how to do this for a single database using powershell, but what we really need is a report across our environment(80+ databases) that indicates differences in TABLES, COLUMNS, and INDEXES. I see this implementation as a text file with the listed <server>\<instance> and then a parameter added to the commandline which accepts the UNC Path of the file.
                            I could run 1:1 comparisons in a loop, but bringing this together in a single report would DRASTICALLY INCREASE THE VALUE OF THE PRODUCT. …

                            14 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 →
                            • ignore constraints

                              Option to ignore missing default constraints. Often when comparing two table defs, I want to see if columns or data types have changed but am not concerned at that moment about default constraints. Would like to see an option to ignore missing contraints.

                              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 →
                              • User interface suggestions

                                There are some minor issues in SQL Compare UI, the newer UI.

                                I was going to send an image but I don't see how.

                                1. the column 'Type' is very narrow, so you need to widen it just to see the words.

                                2. the columns Object Name, are both super wide (I have a wide screen), wasting horizontal space.

                                3. the Updates Available alert band, blue, across the top... partially obscures the 'Deploy' button and is quite confusing the first time it happens. this should be a popup or some out of the way alert.

                                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 →
                                • does not copy credentials from SSMS 2014. please fix asap

                                  using SSMS 2014 and SQL compare 13, it does not copy credentials over. this is a pain in the arse. please fix.

                                  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 →
                                  • Merge stored procedure differences line by line

                                    Add the ability to merge differences between two stored procedures into a new file that can be ran on the server on a line by line basis.

                                    I.E. 10 lines are different in a stored procedure between a file in a folder and a file on the server. I only want to promote 5 of those differences up to the SQL server, adding the ability to merge those 5 changes into a new file would be super helpful instead of having to copy the file from the server and hand merge them.

                                    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 →
                                    • Temporal tables

                                      when creating temporal tables and setting system versioning on begin and end dates The product is NOT verifying if datatypes for Begin and End Dates are datetime2... Therefore when creating migration script the product creates the statement for system versioning... however, the generated script will fail when executed on target database because the columns of begin and end date on target may still be date and NOT datetime2

                                      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 →
                                      • 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 →
                                        • when doing a sync, the UPDATE alerts obscure the top menu and part of the DEPLOY button and info at the top. Please move them.

                                          when doing a db compare and getting ready to deploy.

                                          It seems like almost everytime I do this, there is a 'update version' message that comes down from the top. It covers up the menus I'm trying to use.

                                          The new 'flat' appearance... made it hard for me to realize, what it was, and how to get rid of it.

                                          I would like to suggest finding some other way to give these update alerts. They are in the way, and its difficult to see what they are, and that they obscuring parts of important functional parts of the screen.

                                          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 →
                                          ← Previous 1 3 4 5 18 19
                                          • Don't see your idea?

                                          SQL Compare

                                          Feedback and Knowledge Base