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. Allow using a script as the source database.

    I use Entity Framework in a “Model First” mode. EF generates a script to create the needed database but not to upgrade an existing one. It can be very handy to be able to use the script as the source database. Currently I need to apply the script to a temporary database and then 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 →
    • Allow user to enter default values for non null fields.

      When executing a compare script if a field is added to the target table and the table already has data, the script fails. In the warning tab, add a place to provide a default value to stuff into the new cells. The idea is not to create a default on the column, just populate the values for the existing rows.

      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 →
      • Signed stored procedures require a warning in the deployment wizard

        SQL Compare presently does not warn users if it is altering a signed stored procedure when a script is generated in the deployment wizard. This can lead to procedures being deployed without a signature, breaking permissions for things like dynamic sql where object chaining can't be depended upon.

        If a secure method could be devised, it may also be possible to automatically include the signing password.

        I think similar aspects may also be missing in products like source control too - where the presence of signatures is not source controlled but some aspects of certificates are.

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

                                          SQL Compare

                                          Feedback and Knowledge Base