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. ER Diagram Tool

    It would be really cool if RedGate would consider building an ERD Tool that would allow you to visually design your database schema using drag and drop before deploying to SQL Server (either generating the deployment script or deploying directly from the application)

    9 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 →
    • SQL Compare: Add option to disable the feature "columns were mapped automatically"

      When I want to rename a column I save a script with the ALTER clause.
      The functionality that automatically maps columns can be really annoying and can cause incorrect renames in production databases. I would really like to be able to disable this functionality. I also think that it shouldn't be turned on by default.

      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 SPID

        It would be useful to be able to see the SPID for each red-gate application. That way I can more easily identify the processes in SQL Server.

        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 →
        • compare two different commits from GIT

          Add support for comparing two source control commits through the UI.

          Currently this requires cloning a second repository to perform the 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…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • 2) Be able to exclude users that appear as a schema

            I had that happen with domain/user.

            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 →
            • Comparison view highlights non-changes

              This is similar to the "Ignore Column Order" request. If I have owner mapping on, then anything that has another change, highlights the owner mapping text difference, even though it will ignore it in the sync. It's deceiving as to what will actually be changed.

              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 →
              • user mapping

                My project is being deployed to a different domain. I would like to see a way to map users similiar to owner mapping, like rl\dev = gm\prod or even to a Role. This would greatly help in edge cases of just database upgrades and conversions/moves, like to Azure that doesn't allow domain logins, or it's not a choice

                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 →
                • Increase the length of the Name field on the Deployment screen. Current length is far to small for generated filename.sql.

                  SQL Compare automatically generates a proposed name of the deployment script and displays this in a Name field on the Deployment screen. However the size of the this field is too small to display the full length. Make this Name field at least as long as the Location field found directly below.

                  It would also be nice to be able to configure how this deployment script filename is generated via some keyword definition.

                  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 →
                  • Show/deploy static data changes in SQL Compare UI

                    Please add an option in the UI of SQL Compare to include static data. This would be equivalent to the command-line option "Include:StaticData"

                    If selected it would compare and deploy data changes to the target DB (along with the schema changes), and ideally it could also link the static data table in the target DB if not already linked. Use case is where a new table is created and linked in a dev branch and you want to deploy to trunk.

                    9 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 →
                    • Set Sql Multi Script to Default Editor for SQL data Compare and SQL Compare

                      HI
                      I think this is the good for using SQL Multi Script To Default SQL editor for SQL Compare And SQL Data Compare
                      to update multi sql server database with on compare or one database on one server.
                      thank you very much

                      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 →
                      • One File per object

                        Please provide the option to create one file per object in the compare option so i don't have not split the file manually during release

                        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 →
                        • Allow different Windows Authentication for databases

                          When connecting to a database, "Windows Authentication" only uses the account that launched the application. There should be a way to specify Windows Authentication credentials that are different. We can access one database with one Windows account and another database with a different Windows account. Perhaps we need a connection manager similar to SSIS.

                          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 →
                          • Place table and index schema change at top of migration script

                            I know it has been suggested in the past and declined as it *should* work, but I don't see what the big deal is with putting table modifications first, with index changes right under the table they correspond to. These are top of the object hierarchy and I very often find a table column addition in the middle of the migration script, after a proc that uses the column! Sp_depends even shows the table as dependency, so can't blame that. Using latest 11.3.0.7 version of SQL 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…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Compare database with schema.

                              I have a reporting database, and 3 other servers. all have the same database name on all of the servers. but on reporting I copy server 1 to schema PROD1, PROD2 and PROD3. I would like to compare a database with the schema being dbo on 1 server and something else on another server.

                              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 →
                              • When Force Column Order is unchecked, highlight out-of-place columns light green instead of yellow.

                                When Force Column Order is unchecked, it would nice to have out-of-place columns highlighted in light green instead of yellow. Currently, it's not easy to tell which columns are actually different, from the columns that are identically defined but differently ordered in the table.

                                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 →
                                • BUG: Table-Value types

                                  I created a table-value type in my SQL database. Upon comparing with another database I do not see the diference between the two schemas.

                                  /****** Object: UserDefinedTableType [dbo].[MachineCodeList] Script Date: 10/6/2015 12:48:55 PM ******/
                                  CREATE TYPE [dbo].[MachineCodeList] AS TABLE(
                                  [MachineCode] [bigint] NULL
                                  )
                                  GO

                                  If applicable, please add this to SQL Compare in the future so that I can keep these types in sync across my installations.

                                  Thanks,
                                  Dave

                                  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 →
                                  • Powershell support

                                    There is support for cmd line. But I would like modern full blown powershell support.

                                    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 →
                                    • Select several databases for snapshot creation.

                                      I have 10 databases that I want to create snapshots for. It is tedious to have to choose server and choose db and change the case sensivity then wait several minutes. Then choose next db and wait. Then do this for many servers. Either choose several at once or have some set definition of databases that can be reused.

                                      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 →
                                      • Allow command line options to override args file options.

                                        In the event an Argsfile as a parameter set to a value allow the user to pass in a parameter on the cmd line to override this Argsfile option.

                                        An example would be if you have UserName/Password stored in an argsfile for general use but you need to connect with a different user/password.

                                        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 →
                                        • BUG: Ignore SET QUOTED_IDENTIFIER option ignored

                                          When the option "SET QUOTED_IDENTIFIER and SET ANSI-NULLS statements" is checked, stored procedures are still identified as different when "SET QUOTED_IDENTIFIER OFF" appears at the end of the procedure.

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

                                          SQL Compare

                                          Feedback and Knowledge Base