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. Add targets of 'Scripts folder', 'Backup' and 'Snapshot' to SSMS integration.

    By adding the full suite of targets/sources to the SSMS UI, it would be able to open SQL Compare with the intended actions already filled in.

    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 →
    • Better table type handling

      I have been constantly receiving errors when differences related to table types are detected. SQL Compare does not drop the related objects before dropping and recreating the table type, which leads to errors in deployment. Whenever that happens, I have to run a separate script to handle the situation. If you need it, I will be happy to provide it.

      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 →
      • Version 12

        Newly released version 12 does not show the recently used source control links (URLs), or linked databases. On the previous versions, recent links were shown.

        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 →
        • Exclude temporal-specific attributes

          Add an option to SQL Compare to turn off publication of temporal differences. In my use case, we have temporal tables enables for a staging environment, and publish the 'current' version to another database. I'd like to be able to deploy schema changes to the base table without converting the destination table to temporal.

          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 →
          • merge table schemas

            I have one database that I own, and another database that I have read access to, and I'd like to combine them into one database. I’d need to compare those attributes from each that are obviously similar, and also compare those that aren't so that I can decide which would apply. Having the choice of which attributes to include or exclude would be ultimately helpful.

            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 →
            • Igonre create proc / create procedure commands

              I have some stored procedures created in database A with the statement 'create proc' and in databse B with the statement 'create procedure'.
              An option to allow me to ignore this case will very useful.
              Thanks, Ésio

              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 →
              • Option to delete identical records from Target

                Option to delete identical records from Target.

                I had the need to find all identical rows and remove them from the target as they shouldnt be there. I had to use the export to CSV, and using the data generator create a table with the 81k id's and then perform a delete in sql managment studio on the temp table to delete them.

                It would be so simple an usfull to be able to just select an option to delete identical rows from target in the Data compare or is there an option to control this
                I can choose to…

                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 →
                • Allow Shift+click and Ctrl+click when mapping/unmapping

                  When mapping or un-mapping, please allow us to select more than one item at a time. Typically in Windows this is done via Shift-Click for a list, or CTRL-Click for multiple items not in a list.
                  It's very tedious to select an item, then select map/un-map. And do this for each item.

                  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 →

                    Thanks for the feedback. As far as I can tell from testing SQL Compare 12, shift-clicking and ctrl-clicking does work for unmapping tables and owners, so it might be worth updating to that version if you haven’t already.

                    Mapping multiple objects at the same time sounds trickier, though – if we had more than two objects selected at the same time I don’t know how we’d decide which objects should be mapped to each other. Do you have some idea of how this should work?

                  • Version 12 UI

                    Please support a configuration option to choose either the version 11 or 12 UI theme in the next version. I can't deal with the UI changes on version 12 and had to rollback to 11.

                    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 →

                      Hello-

                      We’d find it really useful to hear more details about what you don’t like about the version 12 UI. Even if we did add some theming options to the UI, it’s very unlikely that it would end up being exactly the same as v11 due to the new features and under-the-hood changes we’ve been working on in the meantime. On the other hand, if there are specific issues that we can fix with v12 then we’d definitely want to look at working on those

                    • Exclude query notification objects

                      .NET apps using SqlDependency are using temporary schema objects. Comparing them is rarely useful. I request as a feature that SQL Compare learns to ignore those objects. They should be easily identifiable by the name and type.

                      See this screenshot http://imgur.com/a/4eRRg.

                      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 new filter rule for other than only Object or Schema

                        Have Dev-QA-Prod environments - push things out in batches so not everything will be in synch - Please add an option on the "Edit Filter Rules" dialog to allow: include/exclude if = property "Last Modified Date" <operator> BETWEEN dates. This way we can narrow down projects we are working on to push to the next environment.

                        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 →
                        • Support CREATE OR ALTER instead of CREATE

                          Sometimes, we create the migration script using SQL Comapare and schedule it for deployment. Then, it turns out, some feature has to to production ASAP, so I create the procedure there manually.
                          I would love the script not to fail in that case, ie. to ignore and overwrite the existing procedure.

                          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 →
                          • Add support for External Tables

                            I use Azure SQL, and there is limited cross-database functionality in that environment. Due to this I have several External Tables that I use to point to a Master Database with shared setting, info, etc. for each customer database.

                            When I used SQL Compare to fill out the schema for a new database it copied all of the External Tables as Local Tables, and it didn't bring over the Data Source either. This could be very handy as dealing with external tables (and especially changes to them) is a pain.

                            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 →
                            • 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 :(

                                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…)
                                  1 comment  ·  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.

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

                                          SQL Compare

                                          Feedback and Knowledge Base