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 http://www.red-gate.com/messageboard/viewforum.php?f=154

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 vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. compare extended properties on the database level

    I'm documenting my databases using extended properties on the database level, and I've tried various options, but I can't find how to compare the database extended properties. We have dev, test, and production environments, so I need to sync these properties between the environments so they don't get lost when restoring dbs between them.

    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 →
    • SQL Compare Command Line should order objects consistently

      I use SQL Compare from the command line to generate scripts for deployment to production. Sometimes I need to see how the script I generated today differs from the one a day or 2 ago (ensure I didn't make manual changes to my DB before generating diff's, etc.).

      The tool seems to put objects of the same type in random order. It would be nice if these were consistent (in order of Commit, alphabetical order, ???)

      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 →
      • Configure timeout settings on command line interface.

        Currently there is a 60 second timeout on all script executions for SCO deployment. I have run into situations where indexes on large data sets or table rebuilds on large tables exceeds that time frame resulting in SCO prematurely exiting the script deployment. The recommendation was to invest in better hardware. Unfortunately, better hardware cannot solve this problem where large data sets are in play. Having the ability to adjust the timeout default could help avoid such situations.

        See for reference issue: http://redgatesupport.red-gate.com/requests/16832

        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 →
        • Exclude objects from compare for the command line interface.

          For high availability, we have duplicate table structures that are referred to by a synonym. We rebuild the structures periodically to reduce fragmentation on full text indexes and to manage very large data loads. SCO will not allow filtering except from a pre-saved project. Should a synonym be changed to point to the wrong underlying table, there could be major problems: incomplete or bad data, corrupted indexes, etc. Additionally, our deployments move through 4 environments: Development, Integration, QA and Production. Creating separate projects reduces any benefit from continuous integration and automatic deployments. Having the ability to exclude objects by name

          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 →
          • 31 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 →
            • ignore extended properties created by the view designer

              SQL Server Management Studio's view designer creates extended properties such as "MS_DiagramPane1" which hold the location and size of each table in the designer. Different developers might rearrange things differently in the designer according to personal preference, but that doesn't change the view. I would like to be able to ignore those extended properties while still comparing and synchronizing other extended properties (like "MS_Description").

              This option exists as "IgnoreInternallyUsedMicrosoftExtendedProperties" in SQL Source Control. Just add it to SQL Compare.

              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…)
                3 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Ability to mirror the database name selection

                Add the option to keep the database names the same (if possible). If Database1 is selected on the source, automatically select Database1 for the destination. This could be a check box that sits between the database drop downs.

                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 →
                • filter with underscore in name doesn't work correctly (possible bug)

                  When applying a filter with "Starts with underscore" it removes all entries with underscore in the name, even when they underscore is not at the beginning of the name. Please fix. My upgrade scripts missed important stored procedures because of this apparent bug.

                  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 →
                  • Command Line: Ability to specify Connection String

                    I'm using your command line SQLCompare.exe utility to update database schema during automated application deployments. However, we're using Database Mirroring, and I need to be able to specify the Failover Partner option.

                    The easiest way to achieve this (and other valid connection string options) would be to support passing a connection string instead of the server1/server2 values. Maybe you could add a "conn1" & "conn2" parameter to be used instead of "server1", "username1", etc?

                    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 →
                    • Firebird Connector - Basic Tooling

                      There are many legacy Delphi users that have to use Firebird (as used by the Chicago Stock Exchange ) and whilst the code base has now moved on to C#, they have no tooling for Firebird. The best is DBConvert that allows you to copy a version of the DB into MS SQL or Azure. Since RedGate uses the ODBC tooling it could also write connector Firebird. This will not only help them manage and document their DBs that for many reasons they cannot more from.

                      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 SQL Compare Users to set the default password

                        When using SQL Compare and deploying a database to a new server, you may experience an error that "Password validation failed. This is caused by the password not meeting Windows policy requirements because it is too short". This is due to the default password generated by SQL Compare called 'p@ssw0rd' being 8 characters long. If your company has a policy for Windows passwords to be minimum of 9 characters, the deployment will fail as the default password does not meet the policy requirements.

                        Would SQL Compare Users like to set their default password for SQL Compare?

                        5 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 →
                        • Script Generation/Deployment should be consistent...but is not.

                          When generating a script from SQL compare, the script should be consistent, in that if I click “Deployment Wizard” 20 times on a database that has not change, the Deployment Script should be exactly the same and the behavior of the “Deployment Wizard” should also remain the same. This is not happening. Some of the issues I am seeing are as follows. 1. If I re-click the Deployment Wizard button after closing the Deployment Wizard, sometimes I get a warning about a dependency, that didn’t exist the first time I ran the “Deployment Wizard”. If I exit the “Deployment Wizard”…

                          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 →

                            Hi Mark,
                            Thanks for contacting support. I’m updating this to be in the SQL Compare forum and for anybody else wondering, this is now logged as a bug in our issue racking system, ref SC-6824.
                            Michael

                          • Dependent Objects included do not show in Comparison Report

                            By default dependent objects are included in the change script For example if stored procedure references a synonym, the synonym is created on the target if it does not exist. But this behavior is not presented in the Comparison report.

                            I believe all objects impacted by the change should be displayed on the Change report, both explicit and dependent object changes.

                            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 →
                            • Give an option to ignore data when deploying changes.

                              Now you are forced to edit the script to remove the INSERT / create temp table / rename / etc... There are times when yuo DON'T want to copy the data.

                              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 →
                              • SQL Compare store options for index create\rebuild

                                First this may be more apparent as tedious in my case, we happen to have large tables with decent sized indexes. I would appreciate if through the setup of a SQL Compare project I could impact index create or rebuild behavior through the selection of on\off toggle for the switches that are available upon creation of an index.

                                I use some options more than others with the most frequently added option being SORT_IN_TEMPDB = ON. I use this because when building large indexes I want to try and avoid as much as possible any unintended file growth by specifying that…

                                5 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 →
                                • Separate primary key from other indexes for ignore index option.

                                  Our indexes are tuned and maintained in production. Database development is done elsewhere and moved using SQL Compare. Therefore we don't want to compare indexes. However, if we don't compare indexes, then the primary keys are not created. If we do compare indexes, there is a real risk that production will be damaged.
                                  This problem could be prevented by treating primary key indexes differently from other indexes. That this is even necessary is an implementation quirk of SQL Server.

                                  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 →
                                  • Ability to open deployment scripts in SQL Multi Script

                                    Add SQL Multi Script to the SQL Editor Options

                                    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 →
                                    • Deployment Wizard --> 3 - Review Dependencies Encorced Inconsistently

                                      This step is often skipped when I click on Next from Step 1. The Deployment Wizard will skip straight to '4 - Review Deployment Script'. This behavior is inconsistent: sometimes '3 - Review Dependencies' IS enforced even though it is skipped and other times it is not. In our situation, the rule is to NOT enforce dependency changes.

                                      This has bitten me several times in the past, so I now always click on Back when on Step 4 to see if Step 3 was enforced or not. Of three deployments today requiring SQL Commpare, two of them exhibited this behavior.…

                                      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 →
                                      • Compare instance level information

                                        Like configuration settings, security info (logins, server roles...), linked servers, jobs, SSIS catalog info for SQL2012 (folders, environments, security, projects, packages...) etc.

                                        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…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Select server from Central Management Server with project setup

                                          We use a Central Management Server to catalog all the servers in our organization. The names of our servers are difficult to remember, so I constantly refer to the catalog when connecting to unfamiliar servers.

                                          When I set up a project for a new server, I have to switch to SSMS, open the Registered Servers view, browse the central management server, copy the name from the list, switch back to SQL Compare, then paste it into the server field.

                                          It would be much more convenient to integrate the catalog into the interface.

                                          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…)
                                            2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 8 9
                                          • Don't see your idea?

                                          SQL Compare

                                          Feedback and Knowledge Base