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. 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 →
                • Remove port number requirement

                  Since upgrading to SQL Compare 13.0.2.5109, I've had to include the port number in the SQL Server name (e.g., "severname,port#") when connecting to a SQL Server instance. It had been a while since I had upgraded, so this may be an issue with older versions as well. Please fix this.

                  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 →
                  • Make SQL Compare easier to use across many database projects by allowing saving project options and filters as template

                    Each of our production SQL servers has dozens of databases on it. We have a SQL Compare project file for each database to compare it between the production and dev servers.
                    Sometimes we find out that we've been using different comparison settings (either filters or project settings or both) between databases that results in us not finding differences that we should have, in hindsight, found.
                    It'd be super if there were a way to define the filters + project settings by at a higher level, and perhaps tied to either the database name, the source server, or the target server. …

                    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 →
                    • Include column name in DROP CONSTRAINT comment

                      When dropping a column constraint, code like this is generated:

                      PRINT N'Dropping constraints from [ref].[VariablesConfiguration]'
                      GO
                      ALTER TABLE [ref].[VariablesConfiguration] DROP CONSTRAINT [DF__Variables__Start__605D434C]

                      Now, I know that, in this case, this is a column constraint for a column being dropped. What I would like to see, especially since this is a system-named constraint, is the column included in the print statement like this:

                      PRINT N'Dropping constraints from [ref].[VariablesConfiguration](foo)'
                      GO

                      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 →
                      • Case-Insensitive compare for Keywords

                        I would like to use case-sensitive object definition. But, it also highlights keywords like COALESCE, VARCHAR, etc. Can you please add an option to keep case-sensitive object definition compare but to Ignore case-sensitivity of keywords.

                        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 →
                        • Missing Server Name

                          SQL Compare needs to display Server name along with the DB name on the results screen.

                          I gave my rationale for this in my last attempt to add a comment when this web page hiccup'd and lost it. Don't have time to retype 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…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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.

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

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

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

                                          SQL Compare

                                          Feedback and Knowledge Base