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 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. Show static data diffrences in report when using command line with /Incude:StaticData switch.

    With /Incude:StaticData switch, static data are included in generated synchronization script, but aren't present in any of avaible reports.

    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 →
    • Improve scripting for ALTER TABLE ADD DEFAULT

      When you add a constraint to a table using ALTER TABLE ADD DEFAULT.. and do not specify a constraint name SQL will create the constraint as DF_tablename_fieldname_GUIDDD. When you run a compare and the constraint needs to be dropped the DROP CONSTRAINT is explicit in it's name. Within an instance(or database name), it appears that the GUIDDD will be created consistently (i.e. you can create a database in your dev environment a number of times and you will always get the same GUIDDD), however in a different instance the GUIDDD will be different and so the DROP CONSTRAINT in the…

      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 →
      • Match up indexes correctly in the comparison Results screen

        It is often the case that in the Comparison Results screen, indexes in the left "source" panel and the right "target" panel are not correctly aligned, and neither the matches nor the mis-matches are shown correctly. This is a serious defect that should have been fixed in SQL Compare a long time ago and I can't believe I'm still seeing it.

        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 variables used in Visual Studio Project

          There are cases when for continuous intergration we use Visual Studio Project 2013 to build our databses. Sometimes we need to use database variables these look like: [$(DatabaseName)]. Though Visual Studio can recognize it as a variable, redgate will not and will output that as it is for deployment or comparison.There need to be an option where these variables can be ignored or output using the variable name which is specified in the project.

          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 →
          • Force Azure compatible script generation

            Allow 2 sources to be compared e.g. 2 scripts folders and force sqlcompare to produce Azure compatible scripts

            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 →
            • Allow preservation of custom indexes in a production destination schema when snapshot is applied

              Currently stored procs, view and tables can be excluded from a snapshot but indexes cannot as they are treated as part of a table definition.

              The problem we have is that if custom indexes are created (with an agreed naming convention) on a production DB, these are lost when a new snapshot is applied.

              I have got around this by scripting out the indexes and re-applying after the upgrade but this can take hours on large tables. It would be a great help to be able to exclude indexes (similar to tables, views etc) in the snapshot so that they…

              7 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 →
              • format comments in comparison results report

                Currently, the Comparison Results Report doesn't format comments in green, and in fact formats SQL statements inside comments as if they were active SQL statements.
                It would be best if the Comparison Results Report used the same formatting used in the Comparison Window itself, but failing that, at least comments should be clearly delineated.
                Since we use the Comparison Results Report to communicate changes for Code Review and QA, it's important to know which SQL statements are commented out and which are not.

                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 Migration scripts to SQL Source migrations

                  When I create a migration script using a source control repository, I should be able to save the migration script to that repository.

                  If not, in SQL Source control I should be able to import migration scripts.

                  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…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Enable the ability to compare SQL Server 2014 databases and SQL Server 2014 compressed backups.

                    Support comparing SQL Server 2014 databases and SQL Server 2014 compressed backups.

                    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 →
                    • Primary key with constraint name won't replace unnamed PK

                      Two tables, one with the PK defined with a "constraint" keyword and name, the other with only the name. SQL Compare only generates the create and not the corresponding drop.

                      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 →
                      • Allow Comparison of CDC Objects

                        CDC (Change Data Capture) objects are currently excluded from comparison.

                        Because SQL Source Control uses SQL Compare behind the scenes, this means that CDC objects cannot be committed to source control, which in turn means that databases containing objects (e.g. views) which reference CDC objects cannot be deployed with SQL CI.

                        I don't believe that SQL Compare should compare CDC objects by default, but there should be an option to allow it.

                        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 →
                        • option to ignore case in schema name compare

                          In version 11.1.30.30, I have 2 database where objects only differ because on schema has names that are camel cased and the other is all lowercased; everything else is identical but keeps showing in list of 'objects tat exist in both but are different'

                          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 Last Used column to projects window

                            The projects window currently has columns to show the data source, date modified and project filename. Adding a "Last Used" column here would also be very useful.

                            7 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 projects to be grouped in projects window

                              In the projects window, it would be good if projects could be grouped together. For example, I have different comparison projects for things like "Local to Stage" or "Live to Local", and having to find these in the long list each time is inconvenient.

                              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…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Filter Extended Properties on other objects than databases

                                It would be great to be able to filter extended properties on other objects than databases. We only want to compare certain extended properties on tables, but the Extended Property Filter only works on database properties.

                                This is similar to this idea: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/5680027-ignore-extended-properties-created-by-the-view-des (which would be solved by filtering out "MS_DiagramPane1" on the view)

                                And suggestion #2 in this forum thread: https://forums.red-gate.com/viewtopic.php?f=177&t=77849&p=136399

                                7 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 →
                                • An 'ignore' option for differences between varchar and nvarchar datatypes

                                  Provide an 'ignore' option for differences between Varchar and NVarchar data types.

                                  Databases that require multi lingual support can use the NVarchar data type whereas Varchar may be used in databases that don't require multi lingual support or legacy databases.

                                  Need to be able to ignore differences between Varchar and NVarchar otherwise the volume of differences returned can result in SQL Compare becoming unusable.

                                  8 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 →
                                  • Use ALTER INDEX REBUILD WITH to change FILLFACTOR

                                    Use ALTER INDEX REBUILD WITH to change FILLFACTOR instead of dropping PKs, FKs, etc and reconstructing everything from scratch

                                    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 →
                                    • Change Red Gate Defaults

                                      I would like to suggest that the option 'Behavior:Force Column Order' be checked by default, and the option 'Ignore:Filegroups, partition schemes and partition functions' be unchecked by default.

                                      It is important to have ‘Behavior:Force Column Order’ checked, because otherwise RedGate will put any columns added during table modification at the end of the table, rather than in the same location as the source database. Similarly it is important to have ‘Ignore:Filegroups, partition schemes and partition functions’ un-checked, because otherwise RedGate will use the primary filegroup for new tables and the clustered key filegroup for new indexes on existing tables, rather…

                                      11 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 add additional connection parameters

                                        In SQL Server management studio you have the ability to add additional connection parameters however there is no ability to be able to specify these in SQL Compare. This is a problem in SQL 2012 when trying to connect to availability group listeners that have replicas in multiple subnets. In order to connect to the availability group listener you need to specify the “MultiSubnetFailover=True” connection property, otherwise it results in a 50/50 chance of connecting successfully.

                                        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 →
                                        • Speed up comparison from a database backup.

                                          Currently it is faster to manually restore a backup and then perform a comparison to using the backup file as a source. This is true for larger databases where the 'Registering Data Sources' step can take up to 40 minutes. It would be good if this process could be improved.

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

                                          SQL Compare

                                          Feedback and Knowledge Base