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. Get compare to pick up difference in Columnstore index columns order

    Currently compare is showing as identical when they are not. Columnstore Index columns are in a different order

    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 →
    • print compare result option removed

      print compare result option removed

      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 →
      • Enhance filtering when checking "Deploy all dependencies" option

        The screen "Deployment" give us all necessary information about depencencies. By design: „Objects excluded by the filter are only included in the deployment as dependencies" - documented property.

        1. There is no warning signal (or at least, coloring of that objects) on the Deployment screen, when between „dependencies” (~180) there are unvanted (filter excluded) objects;
        2. I have no possibility to force Your tool to use the main filter for the dependent objects too – of course, on my own risk

        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 →
        • Visually show/manage migration scripts in SQL Compare

          When doing compares that have migration scripts, I think it would be incredibly helpful to SEE them in the GUI and not "buried" behind the scenes. I am not exactly sure how to show them but one suggestion is that if there is a migration script for a table then indent that migration script underneath the table it is touching. And just like other objects, you can un-check the migration script if you did not want it to go at that time.

          As far as the "manage" side, instead of having to open the JSON file to reorder or modifying…

          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  ·  Flag idea as inappropriate…  ·  Admin →
          • Ability to store/recall previously used credentials when selecting a server&DBinstance.

            RE: request (#83551)
            An "autofill" option (separate from SAVE PASSWORD checkbox) that will allow the software to pre-populate credentials with those used last/previously based on the server&DBinstance chosen.
            Software should give users the option of even storing this sensitive information in the first place, some may not want that - some do.
            This would be _similar_ to how SSMS does it when you choose a server to connect to (when its been used previously, ie. caches creds).
            This feature would apply to RedGate Compare and RedGate DataCompare for sure - but likely any other dialog out there that works on…

            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 →
            • Include full support for Temporal tables in SQL Server 2016 databases

              As of version 12.1.0.3760, SQL Compare is still unable to generate code to create Temporal tables. It just ignores the Temporal table specific syntax from the source tables and creates the tables as if they are non-temporal.

              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 a keyboard shortcut for next and previous difference buttons

                Please add a keyboard shortcut so it's possible to navigate the various differences in a file/object.

                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 →
                • Get Compare to ignore Column order when comparing tables.

                  Since the latest update, column order is not ignored, and I get mismatches due to columns being in a different order, with NO other difference.

                  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…)
                    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Add Summary Details to Script

                    It would be helpful if the comment header of scripts generated by SQL Compare included the list of Actions present in the Summary tab of the Deployment dialog box.

                    We keep copies of all Production deployment scripts, but without scanning through the entire script, it can be hard to identify what is going on in each script. Having an option to include that data in the comment header would make it easier for us to track down and review what changes went out with what release.

                    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 Last Modified Date Column to Comparison Report

                      Add the Last Modified Date Column to the Comparison Report, like it's shown in the Application.

                      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 →
                      • Trim leading and Trailing spaces in Search box while searching.

                        While i copy/paste an object name from excel or word for that instance it might have a leading or trailing space along with it which makes the search result show empty due to an exact compare.

                        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: comparison vs deployment

                          I ignore lots of things when using SQLCompare, and I think you have supported this pretty well. But when I decide to deploy something, I don't want the generated script to ignore ANYTHING (well maybe collations). But in general I want to script the source object in full when I choose deploy. If other people truly don't want the generated scripts to include things excluded when comparing, then RG could solve this by duplicating the "Ignore" settings as a "Do Not Script" settings section. If you did this I'm positive you would find most folks using different config in the…

                          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 →
                          • Handle signed stored procedures. We have procs that do not function unless signed with "ADD SIGNATURE ..."

                            At least in situations where there is no pwd, SQLCompare should generate the signing statement "ADD SIGNATURE TO" stmt. All of our signed procs are signed by certificate, and I can see no reason the ADD SIGNATURE stmts could not be appended to the object script just like GRANT EXEC stmts are. TSQL for this is trivial and I don't see any potential security problems. If pwd is involved, then as another customer has suggested, at least issue a warning (or a partial ADD SIGNATURE stmt...I don't know, don't care that much, not using pwds for these).

                            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 compare tables in different schemas (tables in source schema vs. tables in tgarget schema)

                              Currently comparing [dev].[employee] to [prod].[employee] can only be done using manual mapping. Comparing multiple tables in this way is a tedious task. Please add an option to select the source and target schemas.

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

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

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

                                          SQL Compare

                                          Feedback and Knowledge Base