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 http://www.red-gate.com/messageboard/viewforum.php?f=154

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 vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Support "Ignore Column Order" in comparison window

    If the only difference between two tables is column order, the the table shows under Identical Objects section. But if column order AND something else is different, the comparison window hilights the out-of-order column.

    72 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…)
      7 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Mark a difference as a known difference to be ignored in future comparisons

      When I am comparing 2 DBs, there are many differences that I want to ignore - is there a way to mark some differences as known so that they can be excluded from comparison when needed

      60 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 →

        Currently, you can save a project file with some objects deselected and the deselection will persist whenever you load the project unless there are major schema changes / database name changes which mean we can no longer identify which object you meant to deselect.

        You can also filter out objects that you know will continue to be different by object name from the filter panel.

        What does this suggestion mean in addition to this functionality, to you?

      • Format compare using SQL Prompt format

        Ability to format the source and destination code to ensure compare is using the same structure.

        47 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 →
        • Display Last Modified

          I've asked for this many times since SQL Compare 7.

          Please allow us to see the Last Modified Date on the objects. The information is VERY easily obtained.
          select object_id, Modify_date from sys.objects where type='P'

          It would be very useful and beneficial to see.

          40 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 →
          • option for "file per object" deployment script

            Our operations team does deployments and would appreciate getting a "file per object" set of scripts that they can better review (and then run from MultiScript) instead of one big script of all changes. Presumably there is a stage where this information is available on a per object basis so I'm hoping this is a relatively minor request. Thanks for your consideration

            35 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…)
              4 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Choose source control label as a version of a data source

              Today, SQL Compare allows for two options when selecting a version of a source control data source - latest (head), or any other change set. It would be great if there was a third option: to select a version by label. We use labels as a means for controling which code is promoted from development to test to production. Anything ready to promote is labeled as “build ready.” It would be great to use this build ready label when selecting the version from the repository.

              34 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 →
              • When tables have different number of indexes the compare will show differences when in reality the indexes are the same, just not aligned.

                A table on server 1 has 2 indexes. The same table on server 2 has 4 indexes. Depending on the order that the script generates the DDL the compare might show all 4 indexes as different/new where it should show 2 as the same and 2 new.

                32 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 →
                • 31 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 →
                  • Color-coding servers

                    For safety when moving among servers, I have the desktop backgrounds of my servers color coded as follows:
                    My workstation - green
                    Other developers' workstations - blue
                    Development - yellow
                    UAT - orange
                    Production - red

                    In SQL Server Management Studio, I've colored the status bar for any query window in the corresponding servers the same way.

                    It would be nice if I could color-code the two halves of the "compare to" window in SQL Compare and SQL Data Compare the same way, based on the server/instance name!

                    Even better, could it pull the color values from some SQL Server…

                    30 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 →
                    • Allow third party comparison program

                      It would be nice to be able to use a 3rd party text comparison instead of the built-in comparison view. Your comparison is really weak, and you cannot compete with features of dedicated programs. Why don't you do what you do the best, and let your users take advantage of the dedicated text comparison program like Beyond Compare or WinDiff?

                      30 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…)
                        4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add BACPAC to SQL Compare (and SQL Data Compare)

                        At the moment you can compare Database, Backup, Snapshot and Source Control.

                        Please add a BACPAC file as well.

                        A BACPAC is an artifact that encapsulates the database schema as well as the data stored in the database. The BACPAC is a Windows file with a .bacpac extension. Similar to the DACPAC, the BACPAC file format is open – the schema contents of the BACPAC are identical to that of the DACPAC. The data is stored in JSON format.

                        How to: Import and Export a Database (Windows Azure SQL Database)
                        http://msdn.microsoft.com/en-us/library/windowsazure/hh335292.aspx

                        Import a BACPAC File to Create a New User…

                        30 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 →
                        • Ignore Server Name in Schemas and Users

                          When comparing the same database in two environments (ie: Development vs Production) it would be nice if there was an option to ignore the server name portion of Schema and User objects. This would need to effect all SQL objects that reference Schemas and Users (ie: Roles, Grant Statements etc.)

                          For example, lets say you are comparing two copies of the same database on two different servers (Server1 & Server2). On both servers there is a User that represents a local windows group called "App Users". The User names are "Server1\App Users" and "Server2\App Users".

                          The current functionality shows the…

                          25 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 →
                          • Please add the ROWGUICOL to the ignore list

                            If you restore a database backup from an Azure database locally and compare this database with a non-Azure database the ROWGUICOL attribute is shown as a difference.

                            ROWGUICOL is not supported in an Azure database and will also be ignored if you deploy from SQL Compare.

                            Please add the ROWGUICOL to the Tools, Project Options, Options, Ignore list just like for example NOT FOR REPLICATION.

                            I know that the ROWGUICOL is ignored if you compare an Azure database *directly* to a non-Azure database, but I would also like to specify this manually. So we can also local databases that has…

                            24 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 →
                            • Restore permissions after drop and create

                              When an object needs to be dropped and re-created as part of a script, restore the permissions on the object as part of re-creating it.

                              Currently, if the Ignore Permissions option is set to true, objects are dropped and re-created with no permissions.

                              20 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 →
                              • 20 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 →
                                • Ability to select types of differences to deploy

                                  Options to select what type of differences to deploy, e.g. data types, primary keys, constraints, foreign keys, indexes, ...

                                  20 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 →
                                  • Ignore DEFAULT(X) column constraints

                                    Replicated (push) tables do not contain default column constraints on the subscriber which are identified as breaks within SQL Compare 10. Provide the ability to ignore DEFAULT(X) properties on column within the UI.

                                    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…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 64-Bit Version

                                      Create a 64-bit version of SQL Compare.

                                      17 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 →
                                      • 16 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 →
                                        • Cross-database dependencies develop a composite script

                                          SQL Compare is currently a database-by-database comparison tool, which works OK in most instances. However, when one is presented with a SOLUTION that employs multiple databases and there are cross-database dependencies, SQL Compare provides no help in developing a "solution deployment script" that is aware of and correctly sequences changes to each database when one or more cross database dependencies exist and are part of the changes to the Solution.
                                          If DB1 references tables in DB2 and some SP's in DB2 reference tables/functions/views in DB1, we must manually carve up and interleave the scripts generated by SQL Compare.
                                          It would…

                                          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…)
                                            2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 8 9
                                          • Don't see your idea?

                                          SQL Compare

                                          Feedback and Knowledge Base