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. Exclude LANGUAGE for fields during schema compare

    I'm comparing a table on two databases that has a full-text field with different languages. We run a number of websites in multiple countries and languages, largely using the same schema in their databases. The ONLY thing that is different is the language for the full-text index.

    It would be very good if there were a way to EXCLUDE only the LANGUAGE for a full-text field in the comparison. I still want to compare the whole schema and make required changes EXCEPT the language part of the full-text field.

    At the moment I am forced to update the schemas 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 →
    • Run SQL Compare on Linux/Mac

      I know weird to with a MS SQL Server, but many people who have been on the platform for a while now have developers with Macs, and automation systems on linux. DLM Automation is pricing some of us out of the Redgate ecosystem. With SQL server now running on Linux seems a reasonable path. I sure hope our beloved sql compare is not going away :(

      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 →

        Thanks for the suggestion – we don’t have any current plans for a cross-platform SQL Compare, but from some of the brief investigation we’ve done it seems like it might be plausible to get the commandline working as a first step (since we’d probably end up having to port the UI to a new UI framework). Would just having the commandline available be useful to you in particular?

      • Colors and screen format need help

        Main window which displays comparison results needs more color so differences standout. Little black boxes to indicate same, differences, left, right are not easy to quickly focus on. Must be a bug with the window sizing. Cannot size comparison results screen which spreads all content out and server/db for source and target at opposite sides of my 24' monitor. Can't size columns either.

        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 →
        • Only show tables from mapped owners (database schemas)

          In SQL compare, If I have two schemas (dbo and test) in some database, and only map the test schema between the databases to be compared, when it comes to table selection, it shows all the tables in the dbo schema as unmapped. That is true, but I'd rather not have to see them. Suggestion: Hide the tables in unmapped schemas.

          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 →
          • Did you do any usability testing for 12? It's terrible.

            Are you lemmings following off the cliff of the Office 2013 "flat" interface unusability? The new interface is downright dangerous when I'm doing DB comparisons compared to the old interface. I'm finding myself checking everything thrice because I'm not sure what's about to happen when I press the "deploy" button. I expected better from Redgate.

            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 →
            • I hate the new look of 12. Hurts my eyes.

              The look is distracting and garish. Makes it hard to read.

              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 →
              • Verify/validate Stored Procs, Functions and Types on Source database before compare

                I'd like to make sure all stored procs, functions and types are valid in the source database before I do a compare and deploy changes.

                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 →
                • 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.

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

                                          SQL Compare

                                          Feedback and Knowledge Base