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. 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…)
          0 comments  ·  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.

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

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

                      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 →
                      • Fatal Error in generated Update Script

                        This is an example off a generated SQL Script -> The Error is, that the first four first Fields are missing in the Insert Statment.

                        PRINT N'Rebuilding [dbo].[relation]'
                        GO
                        CREATE TABLE [dbo].[RG_Recovery_1_relation]
                        (
                        [parentid] [int] NULL,
                        [objectid] [int] NULL,
                        [ordinal] [int] NULL,
                        [relstatus] [int] NULL,
                        [reltstamp] [varchar] (20) COLLATE Latin1_General_CI_AS NULL,
                        [relguid] [varchar] (40) COLLATE Latin1_General_CI_AS NULL
                        )
                        GO
                        IF @@ERROR <> 0 SET NOEXEC ON
                        GO
                        INSERT INTO [dbo].[RG_Recovery_1_relation]([reltstamp], [relguid]) SELECT [RELTSTAMP], [RELGUID] FROM [dbo].[relation]
                        GO
                        IF @@ERROR <> 0 SET NOEXEC ON
                        GO
                        DROP TABLE [dbo].[relation]
                        GO
                        IF @@ERROR <> 0 SET NOEXEC ON
                        GO
                        EXEC sp_rename N'[dbo].[RG_Recovery_1_relation]',…

                        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 →
                        • Color of SQL Compare Icon after 11.5 update

                          Please change SQL Compare Icon back to blue; If you use both SQL Compare and SQL Data Compare now after 11.5 update they are red.

                          12 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 →
                          • Add Role Membership comparison

                            Add an option to compare Role Membership separate from Roles themselves. I want to ensure that roles and the permissions on those roles are present but I do not want to compare membership in the roles.

                            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 an option to ignore the Unicode differences in Extended Properties.

                              Add an option to ignore the Unicode differences in Extended Properties. SQL Compare currently will differentiate between Extended Property text (e.g., for MS_Description) created as Unicode vs Ansi (e.g., N'My text' vs 'My Text'). SQL will apparently maintain this different even though scripts generated from SSMS always show it as Unicode (with N). Thus, this can cause SQL Compare to show differences between two databases where there is none intended (the description text is identical).

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

                                Compare database properties such as owner and TRUSTWORTHY

                                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 Copying Compare Results From Top Panel

                                  It would be awesome if there were a way to copy the results from the top panel into the clipboard. For example, if I highlighted some lines (yellow) and right-clicked, it would be great if there were a copy option.

                                  I would expect the copied data to include the same values as show in the panel in a tab delimited format suitable to paste into Excel. This would make it very easy to at least be able to say what's different or the same in an email or start a conversation between devs and dbas. It would not be necessary…

                                  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 →
                                  • Icon gets lost during update.

                                    Every update, the icon image disappears from the windows task bar leaving just a withe placeholder. Need to un-pin / pin SQLCompare to fix 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…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Surface 1 CLICK function to show: dropped / new tables / fields / views

                                      MOST IMPORTANT DIFFERENCES:

                                      99% of times just need to know: dropped / new tables / fields / views

                                      Surface a 1 CLICK function to show this most critical information.

                                      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 →
                                      • Connecting to SQL Database By Using Azure Active Directory

                                        With Azure SQL Database there is an option to connect by Azure AD account. It is one of the first citizen authentication type in Microsoft Management Studio 2016.

                                        I suggest adding this types of authentication into RedGate products (especially into Compare and Data Compare).

                                        Details here: https://azure.microsoft.com/cs-cz/documentation/articles/sql-database-aad-authentication/

                                        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 →
                                        • In project options add option to ignore sparse columns

                                          As per title. I currently have some columns that are sparse in a development DB, but not in production. I'd like to be able to ignore these differences whilst I check for any other differences between the two DBs.

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

                                          SQL Compare

                                          Feedback and Knowledge Base