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=200

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

    When comparing between two snapshots, remember the folder each side originated in.
    If I have a PreDeploy and PostDeploy folder containing snapshots of databases, within SQL Compare I would like to recall which folder I was in for each side of the comparison. One side will be Pre the other Post. Current functionality only remembers the last folder you were in. So I must bounce back to the other one each time I choose a new snapshot to compare.

    scenario is this. I make a change to multiple databases. I create multiple pre snapshots, named simply with the databasename. and…

    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 timestamp - binary 8 differences in databases

      It is an option in sql replication to map rowversion/timestamp columns to binary(8) columns. It would be a nice option for sql compare to allow for this difference between databases. Without it every table is flagged up as being different which is a headache.

      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 a "no graphics" option to SQL Compare 12

        SQL Compare and SQL Data Compare were fairly straightforward in version 11. Version 12 has introduced all sorts of confusing, ugly and non-standard graphics to the product that make it harder to use and distract from its core purpose.

        Please introduce an option to turn off the graphics and make it look like a standard Windows application again. Version 12 is very hard to use now.

        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 →
        • BUG: SQLCompare 12 - Filter not working for extended properties

          Unselecting "Extended properties" in the filter does not exclude differences in MS_Description. Another way to solve this would be to add project option "Ignore MS_Description".

          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 →
          • Bring back the Project Browser in Compare 12

            The Project Browser, that could be opened at startup, was replaced in Compare 12 with a much less useful standard Open File Dialog. Please bring back the browser. See also, https://forums.red-gate.com/viewtopic.php?f=200&t=80066

            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…)
              2 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Multiple repositories in Command Line Interface

              Using the GUI, it is possible to compare separate folders in source control. However, using the CLI with /ScriptsFolderXML, only one folder can be configured.

              Please split the command line option to /ScriptsFolderXML1 and /ScriptsFolderXML2, to support separate repositories for source and target, similar to other command line switches.

              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 →
              • Bring back the missing buttons that size the differences pane

                I really miss the three little buttons on the top edge of the differences pane that allowed you to select one of three different pre-set pane sizes. I used it constantly and thought it was a very useful, time-saving feature.

                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 →
                • Version 12 crash report - let me view data being sent

                  I sent two crash reports today. (Unhappily the first time I ran version 12.) It did not describe or let me see what was being sent. I don't really feel comfortable with that. I'd like to know what is being sent before I send any more reports.

                  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 →
                  • Version 12 Login Every Time?

                    Version 12 of SQL Compare and SQL Data Compare say that I only have to login to activate the products but they ask me to login every time I use them.

                    Shouldn't the login go away after I've done it once and activated?

                    Ray

                    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 →
                    • Some way of using the data and schema compare tools together

                      Some way of using the data and schema compare tools together - DB Ghost is perhaps the only tool that looks at data and schema - and that is useful?

                      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 →
                      • Have snapshots and SQL scripts default to being named with data & time

                        Have snapshots and SQL scripts default to being named with data & time

                        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 →
                        • Be able to turn off automap

                          Be able to turn off automap

                          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 →
                          • Ability to ignore non-existent windows accounts when copying database

                            Domain user xxx\yyyyyy no longer exists. The create login will not execute, but you put it in there. Allow me to ignore user 'xxx\yyyyyy' and don't reference them in the deployment script.

                            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 →
                            • Test for database users before creating them

                              For example, add an "IF" as below:

                              IF NOT EXISTS (SELECT * FROM sys.database_principals where name = 'xxx\yyyyyy')
                              CREATE USER [xxx\yyyyyy] FOR LOGIN [xxx\yyyyyy]
                              GO

                              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 →
                              • User defined types need to be created before they are used in deployment scripts.

                                Tried to copy a database. Among a myriad of other problems, found that user defined types were not created before they were used.

                                SQL Compare Version 11.6.11.2463

                                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 an "Open..." dialog to the Edit Project page

                                  When starting up SQL Compare, it automatically opens my most recently used .scp file.

                                  That's OK as far as it goes, but about half the time I want to compare a different database. I then have two options: edit the great big screen I see in front of me, and run the risk of accidentally hitting 'Save' and overwriting my last saved compare, or find the Cancel button, navigate to the toolbar, and click 'Open'.

                                  It would be really nice to have an "Open" option readily available when I launch SQL Compare.

                                  6 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 an 'Ignore owner/schema' option to SQL Compare

                                    I'd really like this ignore option, so that [UserA].[Table] on the left hand side would match with [dbo].[Table] on the right hand side. There obviously needs to be a warning that this won't work unless table names are unique between owners/schemas (which, in my experience, they usually are).

                                    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 →
                                    • azure database sync exclusion

                                      MS Azure SQL Databases have an option that is still in Preview, Sync. This will put any two database in a data synchronizing mode, in a configurable interval. The triggers that are scripted have a schema id number in them that is unique to the database, so every sync'd table shows as a change during an SQL Compare. I would like a way of either excluding table triggers, or better would be a way of excluding any object related to the Azure schema DataSync

                                      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…)
                                        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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 →
                                        • The application window for SQL compare is very hard to resize...

                                          Provide more support for resizing the app window...not the instance window ...that fine. The app window expands to the whole screen....this gives me the irrates as I need to get at stuff behind the SQL compare window

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

                                          SQL Compare

                                          Feedback and Knowledge Base