Skip to content

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 or our support portal.

SQL Compare

Categories

JUMP TO ANOTHER FORUM

241 results found

  1. There is an option to ignore identity seed values but none for sequence seed values.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. As per:

    https://forum.red-gate.com/discussion/85655/feature-request-sort-objects-in-deployment-script

    When generating the sql compare deployment script - all objects are scripted in a seemingly random order.

    This could be covered by an option to enable/disable it.

    And obviously, there is a dependency order which much take priority first. But after that all objects should be scripted in alphabetical order.

    Use case for this is generating the same update script multiple times and committing it to source control. If this is done during a RC phase, the later iterations of the script will be 90% the same with minimal differences.

    Currently as it stands, objects get moved…

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Can you provide an option in the tool to ignore unmapped tables for comparison?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Currently the status messages in the UI for things like Updates to the application show up as blue ribbons that COVER THE SERVER NAMES. That's annoying. The choice are to be reminded again later or skip the message or whatever. But the location for the status message should not cover the server names. Could you kindly move it someplace else? Thanks.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Can you add an option that will add the "RefreshView" statement after Alter statements for views?

    Thank you.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Hello

    It would be great if there is documentation that explains how SQL Compare works. Everything I came across so far explains what it does but I didn't find the actual internals of it. I am particularly interested in how SQL Compare handles the dependencies between various objects. For example, how can it create a view before creating the tables the view is using?

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. When copying text from the SQL View panel, in the resulting clipboard text all carriage returns are missing. A trigger of a few lines of text becomes just one single long line.

    This only happens for texts in the TRIGGERS part, not in the texts of create table, constraints, permissions or functions. There are no visible differences between these texts when looking at the SQL View panel, all texts look normal so this seems like a bug.

    It's quite annoying when you quickly want to fix a small difference, or just want to copy text; you have to step through…

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. When the target of the compare is a scripts folder, SQL Compare will create new items with the schema name as part of the file name, such as "person.Contact.sql".
    Could this be made optional?
    It doesn't affect the filename when altering, only creating.
    This behaviour causes us issues because we use Visual Studio database projects where the schema is part of the path, not the filename. For example such as "AdventureWorks\Person\Tables\Contact.sql"

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. This was the behavior in previous versions (at least it was for SQL Compare 10) and not sure when it was changed. But constantly switching folder paths make it error-prone and annoying. As an example, let's say I first chose Folder A/Folder B as Source and then Folder C/Folder D as Target. If I go back to source to pick another folder, now it points me to Folder C/Folder D instead of Folder A/Folder B as I originally selected.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. Cada vez que é feita uma comparação de database aumenta o uso da memória. Só liberar a memória quando sai e volta pra aplicação.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Add an option that will run post-script to set newly added columns that are of a bit value type and that are scripted with a default value to that value after the addition of a bit column.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. I would like to start using the Red Gate Toolbox but I cannot afford the cost nor will my company pay for it. Is there an option to be billed monthly?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. hello, i appreciate that we only need this feature because my company's processes are lacking but what I would love to have is to be able to...

    right-click an object in SSMS and click an option called something like 'compare against other environment'.

    it would then bring up a message box where you could browse an object-explorer for the corresponding object.

    the use cases I see all the time for this are

    1. when people have stored procs next to each other called

    spSomeProc
    sp
    SomeProcv2
    sp
    SomeProcnew
    sp
    SomeProc.old

    etc on the same database.

    2 when you…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. tsql source has line:
    [CreateDate] datetime default CURRENTTIMESTAMP,
    the script that is generated:
    ALTER TABLE [dbo].[AirFlowData] ADD CONSTRAINT [DF
    AirFlowDaCreat82DA8F3] DEFAULT (currenttimestamp()) FOR [CreateDate]

    Error executing script:
    Incorrect syntax near '('.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Allow for pinning of the Object Definition Box so that it is always visible.

    It would be nice if you could make the ODB (that's what I'm calling it from now on) could be pinned or made to float so that I could reference it as i type.

    The object explorer does provide the same functionality... technically but its nice have the "source" immediately visible as opposed to the multiple folders in the Object Explorer.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. SQL Compare tries to preserve data from table when adding a new NOT NULL column and adds below steps to deployment script:
    1. Create a new table B with same structure from original table A
    2. Perform INSERT INTO table B SELECT * FROM Table A
    3. DROP Table A
    4. Rename Table B to Table A

    The issue:
    For example if we add a new column to a ETL table with 1M rows. We don't need data to be preserved since table gets populated during ETL process. The deployment script without manually remove INSERT statement will take a very…

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. optionally have the ability script out all individual objects, rather having one monolithic deployment script, from the source that are unmatched or have diffs on the target. In my case I have a git repo that needs to brought up to date from a production server (a bit of a reverse of the usual workflow)

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. I think its not removing the 'WITH' when doing remove schema binding for dependent objects

    v 13.7.3.9483

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Most of the first-class objects for Service Broker are comparable by SQLCompare (i.e. queues, services, message types, contracts, service bindings, etc). One omission is Broker Priorities. It would be nice to have those at least comparable by the tool with an obvious next step having the ability to synchronize from source to destination

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. It would be extremely helpful for the compare to highlight the one that is newer. When trying to decide if server 1 or server 2 wins, we need to know which ones were updated more recently on one or the other server.

    Since the date fields are on extreme sides, it's difficult to compare dates.

    Color for the newer one or putting the date columns in the center would be two ways to help with this. Color/bold would be ideal.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?