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. Install updates for all products at once

    I'm using the Update software feature directly from the application. we have 3 products licensed, and i have to run all 3 updates separetely. i would be nice to install all 3 products with one setup run.

    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 →
    • 3 way compare

      Add the ability to compare changes made from one base version in separate development branches.

      For instance, if 2 separate development branches had implemented db changes against the same base version, have the ability to identify objects which have changed in branch1, objects which have only changed in branch 2, and objects which have changed in both branches.

      (I'm referring to branches here - but this should be interpreted loosely - i.e. source control / sql scripts / db / backup / etc. as for other comparisons)

      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 column to table does not refresh a SELECT * view

        This is a problem when a proc calls a select * view and the column now doesn't exist.... proc or function fails to create. While yes select * shouldn't be used, it is in our case.

        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 →
        • Object Existence

          Scenario we just experienced:

          Behavior options were set as follows:

          Add database USE statement (unchecked)
          Add object existence checks (checked)

          Script generated contained several ALTER statements, each with an existence check. The script was run on the wrong database, and the output gave us the impression that it had succeeded (but it "failed silently").

          Example Output:
          Altering [dbo].[spStoredProc1]
          Altering [dbo].[fncFunction1]
          Altering [dbo].[spStoredProc2]
          The database update succeeded

          Result: we found out 6 weeks later that the schema changes were never applied to production. We then had to query for corrupt data and rerun the script; re-apply the schema changes.

          Suggestions:
          -…

          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 →
          • Filter Improvements

            I use SQL Compare very rarely. Most of the time I use it to find the differences between two databases with different structure version. And therefore I need to see in a blink of an eye what dml triggers are missing or outdated or whatever. Currently there is no possibility to filter for table objects like dml triggers.
            It would be very nice if there is an option to restrict the view depending on sub elements like Index, Column, Collation, Trigger.
            Maybe it would be enough if the seach bar at the top would also search the SQL view of…

            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 →
            • Alias/nickname Connections

              I'm connecting to two servers in AWS from my local machine. It'd be great to be able to save an alias/nickname my connections. Example, for these connections; “TCP:X.X.X.100,1433,connection timeout=600” and “TCP:X.X.X.200,1433,connection timeout=600”, I'd like the set an alias of Dev and QA.

              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 →
              • Ignoring table prefixes when doing the automated table mapping.

                I have 2 db's with 500 tables. They all have the same name, except for the table prefix.

                eg:
                dbo.User(ID, Name)
                dbo.ABC_User(ID, Name)

                I want to be able to enter a list of prefixes that will be ignored when comparing the table names. It is not really user friendly when i have to map everything by hand for 500 tables.

                The same applies for table name suffixes

                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 →
                • Add targets of 'Scripts folder', 'Backup' and 'Snapshot' to SSMS integration.

                  By adding the full suite of targets/sources to the SSMS UI, it would be able to open SQL Compare with the intended actions already filled in.

                  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 →
                  • Better table type handling

                    I have been constantly receiving errors when differences related to table types are detected. SQL Compare does not drop the related objects before dropping and recreating the table type, which leads to errors in deployment. Whenever that happens, I have to run a separate script to handle the situation. If you need it, I will be happy to provide it.

                    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 →
                    • Version 12

                      Newly released version 12 does not show the recently used source control links (URLs), or linked databases. On the previous versions, recent links were shown.

                      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 →
                      • Exclude temporal-specific attributes

                        Add an option to SQL Compare to turn off publication of temporal differences. In my use case, we have temporal tables enables for a staging environment, and publish the 'current' version to another database. I'd like to be able to deploy schema changes to the base table without converting the destination table to temporal.

                        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 →
                        • merge table schemas

                          I have one database that I own, and another database that I have read access to, and I'd like to combine them into one database. I’d need to compare those attributes from each that are obviously similar, and also compare those that aren't so that I can decide which would apply. Having the choice of which attributes to include or exclude would be ultimately helpful.

                          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 →
                          • Igonre create proc / create procedure commands

                            I have some stored procedures created in database A with the statement 'create proc' and in databse B with the statement 'create procedure'.
                            An option to allow me to ignore this case will very useful.
                            Thanks, Ésio

                            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 delete identical records from Target

                              Option to delete identical records from Target.

                              I had the need to find all identical rows and remove them from the target as they shouldnt be there. I had to use the export to CSV, and using the data generator create a table with the 81k id's and then perform a delete in sql managment studio on the temp table to delete them.

                              It would be so simple an usfull to be able to just select an option to delete identical rows from target in the Data compare or is there an option to control this
                              I can choose to…

                              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 Shift+click and Ctrl+click when mapping/unmapping

                                When mapping or un-mapping, please allow us to select more than one item at a time. Typically in Windows this is done via Shift-Click for a list, or CTRL-Click for multiple items not in a list.
                                It's very tedious to select an item, then select map/un-map. And do this for each item.

                                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…)
                                  2 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                  Thanks for the feedback. As far as I can tell from testing SQL Compare 12, shift-clicking and ctrl-clicking does work for unmapping tables and owners, so it might be worth updating to that version if you haven’t already.

                                  Mapping multiple objects at the same time sounds trickier, though – if we had more than two objects selected at the same time I don’t know how we’d decide which objects should be mapped to each other. Do you have some idea of how this should work?

                                • Version 12 UI

                                  Please support a configuration option to choose either the version 11 or 12 UI theme in the next version. I can't deal with the UI changes on version 12 and had to rollback to 11.

                                  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 →

                                    Hello-

                                    We’d find it really useful to hear more details about what you don’t like about the version 12 UI. Even if we did add some theming options to the UI, it’s very unlikely that it would end up being exactly the same as v11 due to the new features and under-the-hood changes we’ve been working on in the meantime. On the other hand, if there are specific issues that we can fix with v12 then we’d definitely want to look at working on those

                                  • Exclude query notification objects

                                    .NET apps using SqlDependency are using temporary schema objects. Comparing them is rarely useful. I request as a feature that SQL Compare learns to ignore those objects. They should be easily identifiable by the name and type.

                                    See this screenshot http://imgur.com/a/4eRRg.

                                    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 a new filter rule for other than only Object or Schema

                                      Have Dev-QA-Prod environments - push things out in batches so not everything will be in synch - Please add an option on the "Edit Filter Rules" dialog to allow: include/exclude if = property "Last Modified Date" <operator> BETWEEN dates. This way we can narrow down projects we are working on to push to the next environment.

                                      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 →
                                      • Support CREATE OR ALTER instead of CREATE

                                        Sometimes, we create the migration script using SQL Comapare and schedule it for deployment. Then, it turns out, some feature has to to production ASAP, so I create the procedure there manually.
                                        I would love the script not to fail in that case, ie. to ignore and overwrite the existing procedure.

                                        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 →
                                        • Add support for External Tables

                                          I use Azure SQL, and there is limited cross-database functionality in that environment. Due to this I have several External Tables that I use to point to a Master Database with shared setting, info, etc. for each customer database.

                                          When I used SQL Compare to fill out the schema for a new database it copied all of the External Tables as Local Tables, and it didn't bring over the Data Source either. This could be very handy as dealing with external tables (and especially changes to them) is a pain.

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

                                          SQL Compare

                                          Feedback and Knowledge Base