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

248 results found

  1. When I schema compare in order to copy a database, I often want to create a new database as target. Could it be possible to default the collation of the new database to the one of the already selected source? Or at least make it possible to see the collation of the source database right there in the tool? There are hundreds of collations to choose from, and mostly I get it wrong and then I have to await the compare process and go back and delete the new database and do it all over. Seems like an easy fix.…

    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)
  2. Similar to the idea from Steve Hall for SQL Data Compare, SQL Compare should also get the ability to read backups compress by SQL Server.
    There is a feature for compressed backups, but unfortunately "this compression is not supported" if you try to read from a BAK with the standard compression of MSSQL.
    That would be very important to make partial restores and to have an efficient way to deal with the day-to-day tasks, because bih DBs cannot be handled without compression.

    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)
  3. If I open up Tools --> Application Options in SQL Compare, I see SQL Server Management Studio 19, but not 20 which has been out for months now. And I believe it is the same in SQL Data Compare as well.

    1 vote
    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)
  4. Highlight newer last modified date.

    In SQL Compare, highlight somehow the Last Modified date that is newer/more recent especially in the "in both, but different" category of SQL object comparisons.

    Thinking it would help pick the appropriate object that was worked on most recently.

    3 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)
  5. I use something like domain\UserDEV for development and domain\UserPRD for production.

    I can ignore a users permissions but I don't need a list of users that I know won't exist in different environments.

    This confuses business users when I try to show/demonstrate the exported report.

    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)
  6. It would be great if SQL Data Compare/SQL Compare work with External Tables in Azure Synapse Serverless database.

    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)
  7. Sometimes databases are set up such that each schema is supposed to have the same objects, defined in the same way, as all the others. Ex: SchemaA.Table1, SchemaA.Table2, SchemaB.Table1, SchemaB.Table2, SchemaC.... This is used as an alternative to multiple databases. Unfortunately, not all objects are always set up the same and thus the need to compare them.

    SQL Compare will let you compare a database to itself, and you can use the "Owner mapping" tab to cross the schema names (e.g. map side 1 SchemaA to side 2 SchemaB), but the comparison has to go in both directions (also map…

    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)
  8. Every time a SQL Compare project is closed, a modal dialog pops up to save unsaved changes every time, even if the project was just saved. This dialog should not pop up if the project is not dirty.

    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)
  9. On Data Sources modal, make the Scripts folder dropdown box editable so the folder name can be edited/pasted without having to go into the open folder dialog box.

    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)
  10. We want to use the SQL Prompt view tab in SQL Compare, but you apparently specifically need the SQL Toolbelt or SQL Toolbelt Essential licence.

    We don't have SQL Toolbelt (anymore), but we have both Redgate Deploy and SQL Prompt Professional, and i believe we also have all the tools shipped with SQL Toolbelt.

    Can't this tab also be made available for people using Redgate Deploy and/or SQL Prompt Professional, as we have all the tools/software of the Toolbelt already (i guess), but the bundle is named different...?

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  11. Currently, the deployment wizard allows us to select referenced objects and referencing objects. It would be nice if these could be separated so there were two different options. My scenario is wanting to create a small testable DB and only bringing over the minimal amount of schema to get things working. Dependencies are clearly needed, but I don't need objects that rely on the objects deployed.

    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)
  12. 3 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)
  13. Managing multiple projects is cumbersome with the modal windows that pop up. They also force a clunky workflow when copying credentials from a 3rd party manager to the popup windows.

    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)
  14. I used to review the changes on a separate windows on a vertically aligned monitor. This allowed me to fast review changes of most objects without using the scrollbar.

    Now, for even a small table with constraints, FKs and permissions there is scrolling needed. I need constantly to resize either that upper panel to see objects or bottom one to see changes. SQL review tasks are taking much longer now.

    The Summary view is a nice concept but far from production usability.

    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. I have multiple databases which have the same columns (mostly) but sometimes differing defaults.

    They also have different indexes.

    I'd like to choose to ONLY sync indexes across.

    Obviously the system would need to be intelligent enough to sync only those that have the columns they use/include in both source and destination.

    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. Version 15 adds checkboxes for Encryption and to Trust a server certificate, but if you don't maintain proper certificates you now always need to check the Trust server certificate box on both servers for new comparisons. It would be great if there was an option to default the behavior of these checkboxes to fit your environment.

    10 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. I recently had to use SQL Compare to create a rather large add new and update deployment script.
    I was pleased that it picked up User Defined Types in addition to the normal tables and stored procedures.
    But it did not pick up the permissions for the User Defined Types, and that was a failure point when executing the stored procedures.
    This was my first time working with User Defined Types before, and I thought it odd they needed permissions at all. I did not apply any in the development environment, and they worked there.
    But the error was clearly…

    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)
  18. I have TableOne in DatabaseA and DatabaseB. DatabaseA.TableOne has Trigger1,Trigger2 and Trigger3. DatabaseB.TableOne has Trigger2 and Trigger3. After all table columns are analyzed, DatabaseA.Trigger1 is compared to DatabaseB.Trigger2 and naturally they show as different. I'd like to see Trigger1 "compared" to blank, then both Trigger2s compared, ... Try to match up on trigger name and if there isn't a match, show blank

    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)
  19. Currently, there is an option to ignore constraint and index names. Please separate out indexes from constraint names.

    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)
  20. When starting SQL compare, a blue panel appears on the top notifying me about a new version. This panel hides the names of the database servers I am working with and that is problematic. I think that once I start working/touching anything in the SQL compare UI the ribbon should auto-hide so I will see the database server names I am working on.

    I know I could click install and be done with it but sometimes I am in the middle of something else which cannot wait and the notification is just in the way and I do not have…

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