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. azure database sync exclusion

    MS Azure SQL Databases have an option that is still in Preview, Sync. This will put any two database in a data synchronizing mode, in a configurable interval. The triggers that are scripted have a schema id number in them that is unique to the database, so every sync'd table shows as a change during an SQL Compare. I would like a way of either excluding table triggers, or better would be a way of excluding any object related to the Azure schema DataSync

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

        Fonts displayed in comparison listing are too tiny, especially on Surface Pro 4. Menu bar also not scaled according to Windows Scaling.

        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…)
          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
        • The application window for SQL compare is very hard to resize...

          Provide more support for resizing the app window...not the instance window ...that fine. The app window expands to the whole screen....this gives me the irrates as I need to get at stuff behind the SQL compare window

          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 →
          • Compare tables with different names using the GUI

            I need to be able to compare tables with different names using the GUI interface of SQL Compare.

            Allowing me to customize mapping would be a good way to achieve this.

            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 →
            • Allow resizing the window from a remote desktop

              When remote using Windows Remote Desktop, the main application window is not resizable. The resize cursor does not show when hovering over the edges or corners, and I cannot click and drag to change the size.

              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 →
              • Add option to force "alter assembly" rather than drop/create

                SQL Compare JUST can't manage dropping and recreating changed assemblies correctly, so please add option to force "ALTER ASSEMBLY" that will solve the problem most of the time

                Here is some but not all problems involved:

                We use assemblies in our db, but when one is changed, SQL Compare generates incorrect deployment script. It creates script, which tries to drop all objects (that it can recognize) that reference assembly, then drop/create assembly and recreate all previously dropped objects.
                The script is not working for our db, because:

                1) there is CLR function - system.today - that is used in default…

                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 →
                • Checking or Unchecking item to sync resets position of scrollbar to the top

                  If you check or uncheck an item to sync the scroll position gets reset to the top of the screen and have to manually scroll down to your previous position. Very annoying.

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

                    Version 12.0. Where have the lines gone on the main grid?
                    We still have the right align/left align of the Object names this makes the right aligned column names MUCH harder to read.The HIGHLIGHT of changes is now a non-highlight ie black text on a medium blue makes it difficult to read let alone serving as a highlight. An own goal I'm afraid! PWH

                    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 →
                    • List of objects at top of deployment script

                      At least one of your competitors adorns the top of their deployment scripts with the names of the objects being altered or added. These are grouped by object type.

                      I find this very useful when reviewing a script later, especially when a lot of changes are being deployed.

                      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 →
                      • Difference Reports Should Take Filters and Command Line Options In To Consideration

                        The difference report should not show ALL differences regardless of what is specified in the filter or command line options. For instance if you ignore case sensitivity, then it should not show case sensitive differences in the report.

                        This leads to a lot of confusion by our deployment teams as they look at the changes report and see a massive list of differences, but when they check the actual script that will be ran, there may only be one real change.

                        This was specifically in regards to SQL Release, but i'm told by support that it's due to SQL Compare…

                        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 →
                        • Add a "source option" for nuget package store

                          It can be very useful to add an option for reading from a nuget package store, in addition to "Direct From Source Control" and "Scripts folder".
                          The package should be reached unsing the http url. This is useful when reading from a build server outcome, which can upload the packages to the nuget store.

                          28 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 →
                          • Excluding a user should also exclude their mappings to roles

                            Using SQL Compare version 11 for Microsoft SQL Server, I can exclude a user from the schema comparison:

                            <exclude>Role:MyCustomUser</exclude>

                            This works fine for excluding the user.

                            However, the comparison engine does not exclude the user's mapping to roles. The script includes sp_addrolemember commands for the excluded user.

                            When excluding a user, I expect their role assignments to also be excluded.

                            I suspect this behavior may exist with object exclusions for other object dependencies. Have not tested other scenarios.

                            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 →
                            • Remember location of main window when last closed

                              The main window always opens taller than my screen. I then have to close the modal project window to re-position the main window. The program should remember where the main program window was if not maximized when closing so it opens in same position next time.

                              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 →
                              • Don't warn me about "loss of precision or data" when I am increasing column size

                                When changing a column from DECIMAL(7,2) to DECIMAL(8,2), I received a "High: Loss of precision or data" warning.

                                Increasing a data type should not result in this warning, since I'm using a larger data type.

                                I haven't tested this using other conversions, but the same logic should apply (e.g., VARCHAR(5) to VARCHAR(10), INT to BIGINT, etc.)

                                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 →
                                • Save location in droplist

                                  Using the Browse button in the Projects dialog doesn't seem to open locations properly and then save them in the drop list. I have projects in a subdir under SQL Compare/Projects and I navigate into it, but the folder is never saved in the droplist. I can't get to any files in there. I have to go to Windows Explorer and double click the project file and launch SQL Compare that way for those projects.

                                  It works correctly in SQL Data Compare. Though this whole method is pretty clumsy for folder selection. Just let me pick a file and save…

                                  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 →
                                  • Deploy Stored Procedure without validation (only as text)

                                    Merging with SQL Compare between environments is a pain for me with Stored Procedures, because the validation fails on:

                                    Stored procedures using Linked servers will fail.
                                    Stored procedures that creates/drops staging tables created when bulk/merging for large imports will fail. (i have a SP that will call a function that creates a table for the bulk. This will invalidate the SP because the table wont be created before the SP is called)

                                    I can still use SQL Compare for comparison, but i will have to run all scripts in hand between environments :(

                                    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 →
                                    • Loose the modal dialog on startup

                                      Almost every time I open SQL Compare, the first thing I want to do is reposition the window (usually to another monitor). However, I can't do this because the app always starts with a modal New Project dialog. Please make the new project dialog a part of the main window so that I can reposition the window on startup, but also not have to click New Project to get started.

                                      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 →
                                      • Find searchbox "starts with..."

                                        In the find searchbox, as offered by SQL Compare 9, we could search an object beginning by "str" if we searched "^str". Why it disappeared in the version 11.5 ?

                                        Maybe I'm missing it but I didn't find any options allowing me to put back this behavior.

                                        PS : I want to avoid to use the the filters because we already use them and it would be really easier and faster to do it directly from the search box.

                                        Thank you :)

                                        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 →
                                        • Deploy SQL Scripts as ALTER

                                          Is it possible to make a deployment script re-runable?
                                          I'd like to be able to generate a change script that can actually be run multiple times.
                                          Example for Table:
                                          if object_id(N'dbo.TableName', N'U') is null
                                          begin
                                          -- complete creation of table since it doesn't exist...
                                          end
                                          else
                                          begin
                                          if col_length('dbo.TableName', 'ColumnName') is null
                                          alter table dbo.TableName add ColumnName datatype null option etc.
                                          ... for each detected change
                                          end;
                                          go

                                          Example - Proc/View/Function:
                                          if object_id(N'dbo.ObjectName', N'Type') is null
                                          exec sp_executesql N'create type dbo.ObjectName /* stub creation code*/'
                                          go
                                          alter type dbo.ObjectName .... rest of script...
                                          go

                                          This will allow me to generate…

                                          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 13 14
                                          • Don't see your idea?

                                          SQL Compare

                                          Feedback and Knowledge Base