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 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. Compare database settings such as snapshot isolation

    Have SQL Compare be able to compare database level settings in sys.databases such as isolation level

    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 →
    • BUG: Deployment fails when changing PK name from implicit to explicit

      my destination DB contains a system named PK as in:
      CREATE TABLE X(Col1 INT PRIMARY KEY).
      My source contains an explicit constraint:
      CREATE TABLE X(Col1 INT, CONSTRAINT PK_X PRIMARY KEY (Col1)).
      The deploy script tries to create the latter without dropping the former, hence script fails

      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 →
      • Separate instances of SSMS plugin.

        Since we can run multiple versions of SQL Compare and SQL Data Compare on the same workstation, it would be great if we could also run different versions of the SSMS plugin. Especially with version 12 no longer supporting SQL Server 2000, it would be very helpful to be able to selectively launch version 11 or version 12 from SSMS.

        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 →
        • 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 update of user-defined table types referenced in sprocs

            This can be achieved by dropping the sprocs which reference the UDT to update, saving their definition, then updating the UDT, and finally recreating the sprocs from the definitions that were previously saved.

            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 me to opt out a single change when there are multiple changes to an object.

              For instance, I have a table that added one column and removed another. I want to review the diff, and un-select the one line that would cause the removed column to be deleted. This feature would be helpful especially for indexes which are frequently different in production.

              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 →
              • match pairs

                Ability to create the pairs within SQL Compare within the same database. For example: I have two catalogs I send out. I have two tables with the same name but each has a different schema

                His.Catalog
                Her.Catalog

                They are in the same database and I need to keep both table definitions in sync. In reality I have 10 tables, I need to keep multiple copies of each in sync within the same database.

                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 →
                • Fix order of operations when populating data from default constraint

                  Probably a bit of an edge case but it caught us out today. If I've changed a column's datatype, changed it from NULL to NOT NULL, and added a default constraint; then the deployment script will attempt to update any existing NULL values in the column based on the default constraint *before the datatype is changed*. This causes a deployment failure on non-convertible datatypes, which is unavoidable in certain directions but avoidable in others. Consider the below:

                  create database db1 create database db2
                  create table db1.dbo.mytable (col varchar(50) not null constraint df_mytable_col_A default 'A')
                  create table db2.dbo.mytable (col int null)

                  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…)
                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • Please do not deprecate /MigrationsFolderXML

                    Hi,

                    We are using SQL Compare extensively in our company department and one of the features we are enjoying is the ability to generate the scriptsfolderxml and migrationsfolderxml on the fly based on which database we want to deploy.

                    In my view deprecating this feature will leave the product in a degerated state. The option is then to use the /migrationsfolder but first I will have to manually sync the migrations folder from source control and then point to it. Sure it is doable but definitely not preferable.

                    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 only certain columns

                      I have a database which is ahead in dev than live and I'd only like a couple of the new columns instead of all of them, I'd like an option whereby under each table, there is tick boxes to exclude column comparison.

                      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 →
                      • Ignore linked server names when comparing stored procedures

                        Ignore linked server names when comparing stored procedures from 2 different environments. For example, in DEV a fully qualified table name is dev_db.db_name.dbo.table_name and in QA it is qa_db.db_name.dbo.table name. It would be nice if the dev_db/qa_db was ignored.

                        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 →
                        • Allow using a script as the source database.

                          I use Entity Framework in a “Model First” mode. EF generates a script to create the needed database but not to upgrade an existing one. It can be very handy to be able to use the script as the source database. Currently I need to apply the script to a temporary database and then compare…

                          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 →
                          • Allow user to enter default values for non null fields.

                            When executing a compare script if a field is added to the target table and the table already has data, the script fails. In the warning tab, add a place to provide a default value to stuff into the new cells. The idea is not to create a default on the column, just populate the values for the existing rows.

                            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 →
                            • Signed stored procedures require a warning in the deployment wizard

                              SQL Compare presently does not warn users if it is altering a signed stored procedure when a script is generated in the deployment wizard. This can lead to procedures being deployed without a signature, breaking permissions for things like dynamic sql where object chaining can't be depended upon.

                              If a secure method could be devised, it may also be possible to automatically include the signing password.

                              I think similar aspects may also be missing in products like source control too - where the presence of signatures is not source controlled but some aspects of certificates are.

                              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 →
                              • Show static data diffrences in report when using command line with /Incude:StaticData switch.

                                With /Incude:StaticData switch, static data are included in generated synchronization script, but aren't present in any of avaible reports.

                                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 →
                                • Improve scripting for ALTER TABLE ADD DEFAULT

                                  When you add a constraint to a table using ALTER TABLE ADD DEFAULT.. and do not specify a constraint name SQL will create the constraint as DF_tablename_fieldname_GUIDDD. When you run a compare and the constraint needs to be dropped the DROP CONSTRAINT is explicit in it's name. Within an instance(or database name), it appears that the GUIDDD will be created consistently (i.e. you can create a database in your dev environment a number of times and you will always get the same GUIDDD), however in a different instance the GUIDDD will be different and so the DROP CONSTRAINT in the…

                                  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 →
                                  • Match up indexes correctly in the comparison Results screen

                                    It is often the case that in the Comparison Results screen, indexes in the left "source" panel and the right "target" panel are not correctly aligned, and neither the matches nor the mis-matches are shown correctly. This is a serious defect that should have been fixed in SQL Compare a long time ago and I can't believe I'm still seeing it.

                                    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 variables used in Visual Studio Project

                                      There are cases when for continuous intergration we use Visual Studio Project 2013 to build our databses. Sometimes we need to use database variables these look like: [$(DatabaseName)]. Though Visual Studio can recognize it as a variable, redgate will not and will output that as it is for deployment or comparison.There need to be an option where these variables can be ignored or output using the variable name which is specified in the 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 →
                                      • Force Azure compatible script generation

                                        Allow 2 sources to be compared e.g. 2 scripts folders and force sqlcompare to produce Azure compatible scripts

                                        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 preservation of custom indexes in a production destination schema when snapshot is applied

                                          Currently stored procs, view and tables can be excluded from a snapshot but indexes cannot as they are treated as part of a table definition.

                                          The problem we have is that if custom indexes are created (with an agreed naming convention) on a production DB, these are lost when a new snapshot is applied.

                                          I have got around this by scripting out the indexes and re-applying after the upgrade but this can take hours on large tables. It would be a great help to be able to exclude indexes (similar to tables, views etc) in the snapshot so that they…

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

                                          SQL Compare

                                          Feedback and Knowledge Base