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

  1. Allow an object / script comparison to be opened in an external Diff viewer, such as Beyond Compare. Provide configuration settings to configure external diff viewer EXE, similar to what source comparison tools do.

    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  ·  Flag idea as inappropriate…  ·  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. SQL Compare in some instances trims the whitespace characters at the beginning and end of object definitions. While in other instances it takes them into account.

    For example when comparing objects directly with IgnoreWhitespace = false it will show the whitespace differences at the end of the object being compared. (See attached screenshot of single direct object comparison)

    However, when you generate a script to based off this comparsion the script does not include the expected whitespace changes.

    SQLServer considers whitespaces at the end of object to be part of the object definition. SQLServer will include any whitespace characters until…

    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  ·  Flag idea as inappropriate…  ·  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. Make 'Ignore Constraints' ignore default constraint values.

    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  ·  Flag idea as inappropriate…  ·  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. When selecting a database name, please allow filtering the list by typing partial strings from the middle of the name of the database name. for example, if my database name is "Database_1335" I could search for it by typing 1335

    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  ·  Flag idea as inappropriate…  ·  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. Include attributes to be changed in an object to an excel report in sql compare. include not only the object name to be changed but the actual change to fields
    within the object or the script change to be made for programability items users roles and permission. e.g. Database.schema.objectinsource.change(details of change column to be altered in a table its original value its new value its datatype and length its nullability and any default constraints.

    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  ·  Flag idea as inappropriate…  ·  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. Allow filters to be case INsensitive
    When I add a filter e.g. schema name begins with "ABC" then objects with schema Abcdef will not be shown even though i have opted for case insensitive matching
    this means that I have to make several OR filters to cover all combinations of upper or lower case letters

    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  ·  Flag idea as inappropriate…  ·  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. When an entire block of code is commented out with the /* */ characters, SQL Compare only shows only the lines with these characters as changed. It does not show the unchanged block of code between them as changed, even though the impact of commenting out this code can indeed be a significant change.

    I suggest that unchanged lines of code enclosed by /* */ around it should still show as a substantive change. When we recently deployed an SP update with a large block of code that was commented out during testing, it slipped in because the scrolling view…

    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  ·  Flag idea as inappropriate…  ·  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. Previously, when running SQL Compare and SQL Data Compare from the command line using a .scp file and .sdc file, the tool would account for the entities to be included as described in the .scp and .sdc file. At some point this behavior changed and now the command line generates a script that contains ALL differences between source database and target database. This broke our automated builds that were making use of the command line. I am requesting that this be looked at again, and that these tools would take into account the entities described in the .scp and .sdc…

    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  ·  Flag idea as inappropriate…  ·  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. Have pop-up screens (My Projects, Compare Progress, Save Script, etc.) open up on the same display as the main program when program is running on a computer with multiple displays.

    I've noticed that if I'm running SQL Compare or SQL Data Compare and move it to my secondary display, it still tries to open up pop-up dialogs on the primary display. This can be annoying, especially if it has been a little while since I used the program and I forget it does this and can't spot why program seems to have stopped responding to mouse clicks. Also, when the…

    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  ·  Flag idea as inappropriate…  ·  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. 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  ·  Flag idea as inappropriate…  ·  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. I was trying to create a copy of the development DB schema into local server. I got errors and warnings. The error I got was in the section of code that created the login and then attempted to create a user (myself). I didn't sent this error as it contained some confidential info. There also needs to be a way to remove things like login names from the generated email.

    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  ·  Flag idea as inappropriate…  ·  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. After explicitly fixing column mapping, I encountered an error when renaming an existing column and then adding a new column using the old name (different casing).
    SQL Compare had scripted the column add before the rename.
    SQL Compare needs to be able to detect the conflict and script the rename before the column add.

    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  ·  Flag idea as inappropriate…  ·  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. On the same screen as specifying the databases to compare, I'd like to specify what objects (tables, procs, functions, ...) should be compared and have the choices saved with the project. Often, I'm looking to see whether I made an update to an object in DB2 that I made in DB1 and I don't need/want to wait for all objects to be compared. Sort of using the object filter ahead of time.

    5 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  ·  Flag idea as inappropriate…  ·  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 had a panic moment after forgetting that the /rad option was added.
    The report made it look like all production users had been removed!

    Please change the color to a lighter or darker shade and add a "filtered" icon with tooltip that clearly explains that the change was not applied due to filters or exclude/include commandline options.

    Kids, don't play tricks on your peers with this option!

    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  ·  Flag idea as inappropriate…  ·  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. Sometimes tables can differ in system column metadata (sys.columns) even if they looks completely identical - for example, if I drop a column in a middle of a table. After copying the table to another DB a column id for a half of columns will be different. But some frameworks or applications we use, rely on it, and require reconfiguration / rebuild even on a such a minor change.
    It will be great to have a feature 'Force Column Numbers' to preserve column id's for table or view on deploy.

    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  ·  Flag idea as inappropriate…  ·  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. 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  ·  Flag idea as inappropriate…  ·  Admin →

    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 frequently need to "generate scripts folder" against large (10k+ objects) databases including encrypted objects (thousands of encrypted stored procs).

    A recent run on a (50ms rtt) vpn link took 2+ hours to complete.

    It appears that object decryption performance appears to be bottlenecked on
    performing 3 round trips to read a single db page, specifically:

    batch 1: dbcc traceOn(3604)
    batch 2: dbcc page(DB, 1, 6573692, 2)
    batch 3: dbcc traceOff(3604)
    batch 4: dbcc traceOn(3604)
    batch 5: dbcc page(DB, 1, 6573694, 2)
    batch 6: dbcc traceOff(3604)

    I think batching page reads (and eliminating many traceon/traceoff commands) would make object decryption…

    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  ·  Flag idea as inappropriate…  ·  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. Please break out the ifg switch in SQL Compare Options so file groups are separate from partition schemes and partition functions. Maybe ifg only ignores file groups, and create a second name ifp (or whatever) that would ignore only partition schemes and funtions.

    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  ·  Flag idea as inappropriate…  ·  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. SQL Compare ignore database scoped credentials. So you wont be able to create external data source from generated script. It's clear that password is not accessible. But if you prepare create statement with data available from sys.databasescopedcredentials and let us fill out secret it will be much better then to skip this object.

    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  ·  Flag idea as inappropriate…  ·  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. We prefix our objects with certain characters, so to right-justify the left Source "Object Name" column names makes it hard to visually read down the list of objects to find something in particular.

    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  ·  Flag idea as inappropriate…  ·  Admin →

    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 11 12
  • Don't see your idea?