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=177

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. 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 more items to “Recently used” drop down? It would save me a ton of time if this drop down could remember just 3 more.

        We have 3 servers with 3 databases in each, so a total of 9 possible connections. The "Recently used" dropdown only displays 6. So I am forced to click the "Browse source control..." option, which results in a lot of clicks to navigate down the tree to the proper location.

        How do I add more items to “Recently used” drop down?

        It would save me a ton of time if this drop down could remember just 3 more.

        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 "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.

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

                      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 →
                      • 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 →
                          • ignore replication stored procedure

                            Please, ignore all objects (mainly stored procedures) related to a transactional replication like: sp_MSdel*, sp_MSupd* and sp_MSins*

                            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 →
                            • Improved deployment of non-nullable columns

                              1. Add column to the table with a default constraint, using a standard value, 0 for int, '' for character, etc
                              2. Drop the constraint

                              The constraint exists only during the deployment and is dropped immediately after the column is added. This has much better performance then using the 3 step process: add null column, update column value, alter column to not null.

                              The interface should include options to set the standard values or to disable this option entirely

                              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 →
                              • Please clean up files in C:\Windows\Downloaded Installations when newer versions are installed! (I have over 1Gb of Redgate install files)

                                Please clean up files in "C:\Windows\Downloaded Installations" when newer versions are installed. (I have over 1Gb of Redgate install files using up my hard drive)

                                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 database names listed in views

                                  I have multiple sets of databases a_test1 goes with b_test1 and a_test2 goes with b_test2. There is a view in the b_test* databases that points to the corresponding a_test* databases. When I compare b_test1 to b_test2 this view is always listed as a difference. I would like an option to ignore database names in views.

                                  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 →
                                  • Include ModifyDate in Compare Results

                                    After the databases have been compared, add the object's ModiftyDate from the sys.objects table along side each object.

                                    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 →
                                    • auto compare after oping a project / mass compare by opening and compare multiply projects at once

                                      Databases should be compared automatically when opening an *.scp project from the file system. Selecting multiple projects from the projects start up view an click compare to compare all database at once would do the trick.

                                      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 →
                                      • Script the database creation and configuration steps

                                        Being able to include the creation of the database as well as the database level options is import for DLM. Currently, SQL Compare doesn't do this. As a result the developer will need to create these scripts by hand. If you are moving to a migration based approach, than this initial script is outside of the migration framework.

                                        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 →
                                        • Ability to select individual indexes

                                          When comparing tables, additions/changes in indexes are included as part of the differences to the table. I would like a way to separate index management from table management. In other words, it would be nice to be able to select a table for modification without including the indexes. I know we can do this from a project level with settings, but if there are many tables selected for change, I would like to be able to include the indexes for some tables and not others. Also, it would be nice to be able to select individual indexes on a given…

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

                                          SQL Compare

                                          Feedback and Knowledge Base