SQL Data Compare

Welcome to the SQL Data Compare feature suggestion list. Find out more information about SQL Data Compare at http://www.red-gate.com/products/sql-development/sql-data-compare/

If you have any questions, need help or have found a bug in SQL Data Compare, please visit the forums at https://forums.red-gate.com/viewforum.php?f=201

How can we improve SQL Data 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. SQL Compare/Data Compare constant CPU/Memory when idle

    Even when not in active use. SQL Data Compare is constantly using CPU and memory. When minimized or in the background it should be idle

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Cannot see all Table Mappings with a large number of unmapped objects.

      If you have a lot of table mappings in addition to the tables that do map, you cannot see all the table mappings.

      I have 61 tables mapped and 54 tables that are not mapped. I cannot map the tables because I cannot scroll far enough down the list to find a matching table.

      3 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Project level variables / merge fields

        We use data compare to run a sync of lots of data across many tables all linked to a specific organization in a multi-tenant db.
        It would be great to be able to define a variable at the project level, e.g. InstanceID, then be able to set a sql comparison to InstanceID = [InstanceID] (or @InstanceID). That way we could copy a project and just edit the InstanceID instead of going into 30 definitions and changing every ID. Would be most useful as a simple text replace, so we could use "between 1 and 2" or like 'abc%'.

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Custom column data equality function / expression

          I'm having some column with data in the source <NULL> and in the destionation "000000" which are equal for functionality. Unfortunately I cannot add a seperate 'function' like you have a WHERE in SQL or a predicate / LINQ in C# to say these are equal.

          This way I have to manually check all 35.000 rows, instead of a much less set or records.

          Thanks in advance.

          3 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • Please add the Server+Instance+DBName in the title.

            If i compare 2 tables with same name in same schema the title does not display which data come from which source.

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • compare two tables in the same database

              I don't see why the tables have to reside in different databases, backup, source control, or scripts folder in order to run SQL Data Compare.

              It wouldn't be much fuzz to add the ability to compare two tables regardless (i.e. in the same database). Sometimes I just need to divide the common traits from the differences, in order to plan some work.

              3 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
              • Include dates code when code was checked in to TFS.

                When I compare (with redgate) the TFS code and the database it would be nice to see when that code was checked in.

                3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Allow us to delete projects from the My Projects screen.

                  Allow us to delete projects from the My Projects screen.

                  3 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Please add demarcation comment lines in the deployment script

                    The different sections of the SQL Data Compare deployment script run together visually (e.g, disabling constraints, delete/update/insert records, re-enabling constraints). Comment lines like this would make the script more understandable at a glance (and easier to review):

                    /**************************************************** Suspend Constraints ****************************************************/

                    4 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Provide option to include USE statement in deployment script (just like SQL Compare)

                      Currently, we have to manually edit every SQL Data Compare deployment script to add a USE <DB> statement at the top. We would like to see an option in the tool like SQL Compare has.

                      10 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • New option: SQL Data Merge

                        We recently had to solve the task of merging two DBs with the same structure in a single DB.
                        The main issue was that identity column values were overlapping in the two source DBs.

                        We copied the first source DB in the destination one and then hoped that we could generate a script with SQL Data Compare that would
                        insert in the destination the content from the second source, managing automatically new identity values.

                        It became clear that it was not possible (we asked for support but he answer was negative).

                        So, it would be nice if SQL Data Compare…

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • optional output clause

                          Since I don't have the permissions to do actual higher-level promotions myself, I usually ask the admin to send me back the results of my changes. One thing that helps me is adding an OUTPUT clause to my DML queries so I can see that the result matches my expectations.

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Go straight to "Deployment" without having to do extra steps

                            Once an SQL Data Compare project is run, these steps have to be executed:

                            1. Click the "Deploy" button
                            2. Click "Next" (with default "Deploy using Data Compare" with all three option unticked)
                            3. Click "Deploy Now" (without saving or copying the script)
                            4. Click "Deploy Now" from the confirm deployment popup.

                            It would be so much more efficient if we could go straight to a deployment without having to do these steps EVERY time

                            3 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                            • Extra space characters in the synchronization script

                              When SQL Compare generates the synchronization script for text columns with multiple lines, it adds an extra space character at the end of each line, so CR+LF becomes ' '+CR+LF. As a result, the values still show up in the list of differences after synchronization.

                              This looks like a bug that needs to be fixed.

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Duration/Time Counter

                                Would like to see a counter for the time that it takes to complete a data compare between databases.

                                4 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • System tables

                                  Please provide ability to compare system tables -- need ability to compare jobs between servers

                                  2 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • An issue with selecting rows of differences table using Space button

                                    Hi, I am using SQL Data Compare and I faced a minor issue as following. after I compared two databases, and selected some differences to deploy using Down arrow and Space button in keyboard I did not use mouse. Then clicked Deployment Wizard button but it showed a message asking me to select differences, however many differences are selected.

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Make Configurable where the "working files" are generated.

                                      Make configurable where the "working files" are generated.

                                      Currently the "working files" go to C:\Users\[username]\AppData\Local\Temp\Red Gate. This is fine for some/most databases. But I've found that when I'm comparing large databases that the "working files" will continually expand until no disk space remains. And as disk space goes down so does the PC performance. This will continue until Data Compare determines there isn't enough space. At that point it tells you about it. All you can do is say OK. But it leaves all the working files still in place. It doesn't "clean up" after itself. You are left with…

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Custom computed comparison key for matching table records

                                        Originally introduced in this thread: https://forum.red-gate.com/discussion/comment/149220#Comment_149220

                                        This is a common problem for us when using Data Compare. Parent table has unique constraint on a char field alongside an identity field which also serves as a one-to-many foreign key in the child table. The child table uses an identity field to distinguish each row but there's no guarantee the id's will be the same across databases so only the parent can be matched but the child table only has the parent_id identity fk which is not a viable comparison key.

                                        My proposed solution would be to allow user to define a…

                                        3 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Add option to use all the columns as a default for key comparison

                                          Add option to use all the columns as a default for key comparison. It's convenient when there are many tables and it's time consuming to set up each table. Also when destination table is blank or doesn't exist, there's nothing to compare. Just transfer all the data without comparison.

                                          11 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 9 10
                                          • Don't see your idea?

                                          SQL Data Compare

                                          Feedback and Knowledge Base