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. Convert to WebApp / Service

    Convert the the desktop app to a WebUI. running a core server infrastructure makes running little desktop apps like this an unwanted overhead.

    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 →
    • Similar to other ideas, any project option to ignore should give ability not to display ignored option finds in comparison result

      The project option gives you the ability to ignore based on certain filters e.g. white space. However, if any other difference is found, when you display the comparison it highlights the things you told it to ignore. If in the case of white space, every line shows a highlighted difference for a white space difference, but the one actual difference you are looking for is impossible to find without scanning the whole comparison. Ignore should give you the ability to ignore in the comparison view also (for any ignore project option).

      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 →
      • SSIS package compare

        I would like to suggest that SQL compare tool also have to support SSIS package compare. Currently I am at the position that I have to compare SSIS packages between two servers and find out if any SSIS packages missing plus if any SSIS packages on old version etc. Currently I am talking about SSIS packages reside in MSDB but even if it can be compare between file system, that will be great.

        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 →
        • 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 me to change my liscense number

            Allow me to change my liscense number

            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 →
            • Scripting Identical Objects

              I am in the middle of merging two databases and it would be of great help to script identical objects as well.

              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 →
              • Make domain users and SQL users not equal even if they have the same name (except for domain name)

                Before SQL Compare v12, domain users and SQL users were treated as two seperate objects when they had the same name (except the domain name).
                E.g. "CONTOSO\john" <> "john"
                Now in v12, these two logins are considered equal. This is apparently by design.
                I would like an option to compare these as the two different logins they actually are.

                12 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 →
                • Choose a subset of views or stored procedures.

                  I work on a purchased package that has many thousands of objects. We added 150 custom views which all all begin with "v_", such as v_projects.
                  Let me compare just my views, and ignore the 2000 vendor views.

                  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 →
                  • Ignore Tabs

                    White space option is ticked but it's still highlighting differences with tabs at the beginning of the line

                    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 →
                    • Command line: create target database

                      The SQL Compare GUI provides the option to create a target database if it doesn't already exist. Please provide a corresponding command line option so that DLM Automation packages can create a deployment target without requiring run-once, handcrafted Powershell scripts.

                      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 →
                      • BUG - Invalid script generated when Unbinding Defaults from columns

                        If some column has a default bound to it, and it is then removed, the script generated by latest version of SQLCompare12 is invalid.

                        See result script below. The related default is [dbo].[CM_Zero], but in the script the comparison of 'default_object_id' the schema part gets duplicated and there will be too many brackets...

                        ...
                        PRINT N'Unbinding defaults from columns'
                        GO
                        IF @@ERROR <> 0 SET NOEXEC ON
                        GO
                        IF EXISTS (SELECT 1 FROM sys.columns WHERE name = N'Type' AND object_id = OBJECT_ID(N'[dbo].[tblCMDefinition]', 'U') AND default_object_id = OBJECT_ID(N'[dbo].[[dbo]].[CM_Zero]]]', 'D'))
                        EXEC sp_unbindefault N'[dbo].[tblCMDefinition].[Type]'
                        GO
                        ...

                        I confirmed that this error is coming…

                        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 →
                        • Optimization of Data Comparison

                          Very simple optimization...

                          If the destination table has NO rows and the source has > 0 rows then there is no need to compare that table. All the rows in the source are NEW.

                          Right now it seems to want to check EVERY row in the source to an empty destination... makes the comparison VERY slow.

                          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…)
                            4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • When loading a script folder that contains a microsoft data project the Collation and SQL server version keep resetting

                            When loading a .scp file that uses a script folder that contains a Microsoft Database Project, the Collation and SQL server version keep resetting. I expected these to be saved in the .scp.

                            Also when it detects a Microsoft Database Project, both of these settings are in the project file. Read those when selecting the scripts folder.

                            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 →
                            • Reinstate display of database snapshot info

                              Prior to version 12 when you selected a snapshot for comparison in the Data sources tab it displayed very useful information such as source SQL Server and date and time snapshot was taken. Put this information back.

                              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 →
                              • most recently used list

                                When the application starts, I would like to see a list of most recently used projects. This list would always have the most recent at the top and allow for friendly names for projects. At present I have to use the menu and click Open Recent, where I am presented with a list of legacy file names.
                                IMHO the new improved UI is a backwards step in this respect.

                                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 →
                                • Option to deploy changes via forced table rebuild

                                  When working on a table with many changes, ie collation, datatypes, nullable etc but no new columns, running individual alter column settings takes a long time. In my case 8hrs. However creating a new table, moving the data to that , drop old table, rename new table took 10 mins. Can we have an option to force deployments via a full table rebuild process?

                                  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 →
                                  • Allow changing of the tab size

                                    In the "SQL Differences" pane, tabs are expanded to 8 characters.

                                    (Can get very messy depending how other employees have formatted the contents of stored-procs)

                                    Could there be a way to allow this to be customized [e.g. to 3 chars] ?

                                    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 Database Name in Stored Procedures, Views, and Functions

                                      We have 3 environments for one of our core applications. Each environment has a different database name: db_proto, db_uat, and db_live for an example.

                                      We keep all the SP, Views, and Functions we develop in a separate database so at no time do we alter the database supplied by the vendor. This database name is the same in all three environments.

                                      Because of the name difference for the vendor database all the SP, Views, and Functions are flagged as different. The only difference for 95%+ of them have is the database name (eg db_proto vs db_uat).

                                      Could a feature be…

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

                                          SQL Compare

                                          Feedback and Knowledge Base