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. Ability to add additional connection parameters

    In SQL Server management studio you have the ability to add additional connection parameters however there is no ability to be able to specify these in SQL Compare. This is a problem in SQL 2012 when trying to connect to availability group listeners that have replicas in multiple subnets. In order to connect to the availability group listener you need to specify the “MultiSubnetFailover=True” connection property, otherwise it results in a 50/50 chance of connecting successfully.

    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 →
    • Speed up comparison from a database backup.

      Currently it is faster to manually restore a backup and then perform a comparison to using the backup file as a source. This is true for larger databases where the 'Registering Data Sources' step can take up to 40 minutes. It would be good if this process could be improved.

      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 →
      • Project Options - option to ignore parameter default values

        Project Options - option to ignore parameter default values. i.e. @fundid INT = 150 and @fundid INT = 152 on 2nd db is diff, option to ignore as may want to have different defaults per db but otherwise check sp.

        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 →
        • By allowing the thing to be updated

          You can't update from 10.4.8.87 to 11.1 - it says it's already installed.
          Which is isn't.
          Considering how much you charge for "support" this is pretty poor.

          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 the Print Command on Deployment Scripts Optional

            Hello,
            We use your compare utility to deploy update's to our software. We have many many changes to our Tables/Views/Procs/etc.

            In each of our deployment scripts there is un-needed Print '......' & Go commands that we don't need.

            It would be nice to have the option of not having these print commands

            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 →
            • Use currently open instance of sql server

              When opening a script in the editor is chosen with sql comapre it opens a new instance sql Server Management Studio even if an instance is already opened, which causes the operation to take more time than if the currently open instance was used by just opening a new tab.

              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 "save as" icon to the toolbar.

                Add a "save as" icon to the toolbar. I use this feature a lot to save a slightly different version of the current project.

                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 →
                • Include new objects by default

                  I need an option to make SQL Compare includes new objects by default. It will help when not all objects from source database should be synchronized with destination database. This was default behavior in SQL Compare 7.

                  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 →
                  • Compare doesn't detect primary key which has the same name as a primary key on another table.

                    I recently ran into a scenario where SQL Compare was insisting that one of my developers create a primary key, yet every time he ran the script it would state that the primary key already exists. After looking into it, I found that someone made a backup copy of this table by rename and create, but the primary key was still on that backup table with the exact same name. SQL Compare should at least warn if the primary key name exists already in the database (currently, there is no warning). When I select the backup table to be dropped,…

                    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 →
                    • Do you have a version for DB2??

                      SQLCompare is brilliant.
                      Do you have a build for DB2?

                      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 →
                      • Compare on object

                        Need an option/ability to re-compare just one object like table, procedure,view or function etc. If my database contains 1000+ objects, if I modify one of them, there should be right click re-compare menu to just re-compare that one object. Instead of comparing the whole database. Comparing whole database take a bit of time when work remotely. Even though I have filters, it takes quite a bit of time.

                        8 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 →
                        • Is there a way to just generate sql to add missing columns, tables, etc

                          Is there a way to just generate sql to add missing columns, tables, stored procedures, triggers to go from one database to another, not make everything the same

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

                            I have to say the tool is fantastic. That said the cost is a little prohibitive for me considering there are some free alternatives out there. These alternatives are not as feature rich as sql compare.

                            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 for certain changes to be taken

                              I have a table in which on both databases they were changes.
                              Now i need the partitioniong from db A but I need to keep the new column added in db B..

                              been using the redgate toolbelt for years, the best schema compare tool! the Visual studio s**** big 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 →
                              • Support for Replicated Databases

                                I would like to push schema changes to a transactionally replicated database. Now, SQL Compare breaks replication when I push schema changes. Please add support for sp_repladdcolumn and so_repldropcolumn rather than ALTER TABLE.

                                39 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: deploying schema changes with migration script

                                  When deploying changes to stored procedures via migration script to handle a necessary data transform, the migration script portion of the script does not have a batch terminator of GO automatically appended to it if missing, which results in the first set of extended properties for the database version number being appended to the code of the stored procedure (up to the first GO in that portion of the script).

                                  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 →
                                  • Snapshots include SQL Source Control revision number

                                    When using the SQL Snapper tool to take a snapshot on an unconnected SQL Server, the snapshot does not include the database revision number and therefore, when comparing it against source control, does not include the necessary migration scripts to get the database up to date.

                                    It would be much better if the snapshot utility included the meta data form the extended properties of a database that specify the revision number in order to better facilitate migration scripts during deployment.

                                    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 →
                                    • Support Last Modified Date for stored procedures

                                      Add an option to ignore changes that are older on one system. For example, usp_Proc_1 was modified earlier on my source system than the destination system, and with this option on, it wouldn't count as a change.

                                      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 →
                                      • When altering a table used in a FK, change event sequence to allow the alter to occur

                                        Altering a table used in a FK constrainte results in:
                                        The following error message was returned from the SQL Server:

                                        [3723] An explicit DROP INDEX is not allowed on index 'dbo.dim_Financial_Chart_Of_Account.ixuc_dim_Financial_Chart_Of_Account__Financial_Chart_Of_Account_ID'. It is being used for FOREIGN KEY constraint enforcement.

                                        The following SQL command caused the error:

                                        DROP INDEX [ixuc_dim_Financial_Chart_Of_Account__Financial_Chart_Of_Account_ID] ON [dbo].[dim_Financial_Chart_Of_Account]

                                        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 support for Microsoft PDW

                                          It would be nice to also support PDW databases

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

                                          SQL Compare

                                          Feedback and Knowledge Base