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

                          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…

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

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

                                          SQL Compare

                                          Feedback and Knowledge Base