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. Include History Table in the comparison of Temporal tables

    Please Include History Table in the comparison of Temporal tables! It is true that the schemas are the same as the main table but you can declare for e.g. different indexes on the history 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 →
    • Provide a warning on the state of the index if it is different (Disabled or Not)

      I have an index on a table in one DB and the exact same index on another DB, i.e. a non-clustered index.

      The second DB has the index disabled but the SQL Schema tool is not informing me of this. Is there any way that I can get the tool to warn me of such scenarios?

      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 →
      • Add SQL Compare Support for SQL Server Analytic Platform System / SQL Azure Data Warehouse

        Microsoft don't fully support database projects for SQL Server Analytic System or for SQL data warehouse. This is a major gap and there's no indication that this support will be delivered soon. Many customers are crying out for this feature because developing code to deploy is very cumbersome and lengthy process (see this thread https://feedback.azure.com/forums/307516-sql-data-warehouse/suggestions/13313247-database-project-from-visual-studio-to-support-azu?tracking_code=5dfc6e2aaba3a1bb277e7748dafebd6d) If you would be able to develop a solution for APS / SQL data warehouse to do compares that would be amazing.

        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…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Alter function default value

          If we have a escalar function that is used to compute a value used as default for a table column or in a computed column, and this function is modified, the Script generated by SQL-Compare should firstly drop de default constraint, then recreate the función and lastly rebuild the constraint. The same reasoning should be applied for computed columns with functions.

          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 →
          • Problem with openquery statements in transactions in deployment script

            Hi Anu
            The only thing I would like to add to this email trail is that sometimes it is not practical to use transactions with a non-SQL server linked server.
            For development:- If the setup option to not hold “open query” statements within transactions could be given. This would allow rollback of all local SQL server changes but omitting remote open queries which we do not have control over. This is for Redgate deployment scripts.
            How does this affect SQL source control, since it uses the SQL compare engine under the hood?
            Kind Regards
            Graham

            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 →
            • Choose parts of both Source and Target side for final output to Target

              My usual diff-ing tool (BeyondCompare), allows me to pick which, from a list of differences, I want to go through to a final version. I guess you might call this more of a merge-conflict-resolver than a diff-tool.

              What is great about this, is that when changes have been made on both sides, I can take the 'best of both', and make sure that those go through to the final output.

              Now, you might say, 'how indisciplined', to have had changes on both sides. But I've found that here, as elsewhere, absolute discipline is an aspiration, but not the answer to…

              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 →
              • Get list of object names that will be affected from command-line

                On SQL Compare GUI, after you compare and select which objects you want to deploy, there is the tab "Summary" that display a list of object names that will be affected by the script. By having it available from the command line, you could schedule sqlcompare to run, get the list and be alerted with an email containing the list of objects names that are different between two database instances

                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 'newlines' as whitespace

                  My usual C#-source-code diff-ing tool, let's me choose a variety of things to lump together as ignorable white space: spaces, tabs, new lines.

                  It would be nice if SQL Compare let me ignore new lines too, directing me to attend to substantive changes between the source and target.

                  I know, 'new lines' on Windows, Mac and unix, are all different [I don't know whether this prints through into the SQL connections your tool makes]. Such is life.

                  Maybe your SQL is better than mine, and you are aware that _some_ new-lines are meaningful, whereas others are not. I can see…

                  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 →
                  • Do diff-ing in both directions (source-to-target and target-to-source)

                    Other diff-ing tools I use for programming, offer me the choice to send changes in both directions.

                    The database I'm looking at currently, seems to incorporate some changes which are making an orderly progression from development-side source to production-side target, and others done expediently, on the server-side.

                    It would have been handy to have had output scripts for both sides: 'changes to be made in production' [target] _and_ 'changes to be made in development' [source].

                    I imagine I can simply turn around the source and target sides of the tool, and send production changes back to development, but it is…

                    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 →
                    • Snapshots via RedGate.SQLSnapper.exe and SQLCompare are different

                      C:\Program Files (x86)\Red Gate\SQL Compare 12>RedGate.SQLSnapper.exe /?
                      SQL Snapper V12.2.1.4077

                      "C:\Program Files (x86)\Red Gate\SQL Compare 12\RedGate.SQLCompare.UI.exe" version is 12.2.1.4077

                      The snapshots of the same database is different using these two applications.

                      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 →
                      • 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…)
                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                        • allow objects to be sorted by Last Modified Date Column

                          currently the objects are sorted by the last modified date 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…)
                            0 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 →
                            • Memory Leak

                              I use SQL compare periodically as I have many clients who have the same core DB and so during development I use SQL compare iteratively to update schema, table and stored procedure changes through the 30 instances of the databases. I noticed that it progressively gets slower and consumes more RAM. Obviously I can close and restart to get a new allocation and it speeds up again. But I noticed that when starting it was consuming about 180Meg, then after maybe 15 compares the memory allocation was close to 1Gig. So something is definitely being allocated and not freed up.

                              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 →
                              • sort linked databases in source control selection list

                                When choosing source control as the comparison source, the list of linked databases should be sorted alphabetically. It appears to be showing them perhaps in the order they were linked or the order they exist in the linked databases config file. This makes it very difficult to find the correct source when there is a long list of linked databases

                                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 summary to preview pane

                                  When comparing two tables with 50 columns imagine the following scenario:
                                  Table 1 has column TimeZoneId as the 3rd column
                                  Table 2 has column TimeZoneId as the 40th column and at the 3rd column a column with a similar name TimeZone

                                  when looking on the table comparison pane I see on the 3rd column
                                  TimeZoneId -> TimeZone
                                  and on the 40th column
                                  removal of TimeZoneId

                                  however the sync script is a drop of TimeZone

                                  I get it that the comparison is text based but this is confusing so I suggest adding an optional summary pane that will show the bit…

                                  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 →
                                  • There's no way to start the toolbox updater to check for updates. When I see the prompt that SQL SourceControl has an update, can't catchit

                                    I get the toast prompt that SQL Source Control has an update but if I don't catch it rightaway I'm out of luck. There's no way to start the toolbox updater. Add a start menu item for 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 →
                                    • Get compare to pick up difference in Columnstore index columns order

                                      Currently compare is showing as identical when they are not. Columnstore Index columns are in a different order

                                      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 →
                                      • print compare result option removed

                                        print compare result option removed

                                        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 →
                                        • Enhance filtering when checking "Deploy all dependencies" option

                                          The screen "Deployment" give us all necessary information about depencencies. By design: „Objects excluded by the filter are only included in the deployment as dependencies" - documented property.

                                          1. There is no warning signal (or at least, coloring of that objects) on the Deployment screen, when between „dependencies” (~180) there are unvanted (filter excluded) objects;
                                          2. I have no possibility to force Your tool to use the main filter for the dependent objects too – of course, on my own risk

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

                                          SQL Compare

                                          Feedback and Knowledge Base