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

(thinking…)

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.

70 results found

  1. reinstate open data compare from schema compare

    Prior to v12, you could run schema compare and then click a button to open data compare with same data sources. seems to have gone now

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  2. Start-up position not saved

    SQL Compare (and SQL Data Compare) still don't save their position on last close. It will always start in the upper left hand corner of the screen. I know this was reported before and it is shown as fixed but I'm running 12.0.30.3199 and it's still a problem on a fully patched Win7 Pro computer.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  AdminDavid Eadie (Software Engineer, Redgate) responded

    Hi Michael,

    This was fixed in 12.0.32.3340 which is currently available on our frequent updates channel. You can switch on frequent updates by following the guide below. This change will be rolled into a default release later this month.

    http://documentation.red-gate.com/display/SC12/Turning+on+Frequent+Updates

    If you are still encountering issue with the start up positioning of the application following this update please could you get in contact with our support team by emailing support@red-gate.com.

    Regards,
    David

  3. Generate USE [database] on top of the script

    Just adding USE [database] on top of the script will help people to guarantee the changes are not deployed to the wrong database, especially when you just copy/paste into SSMS

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Admin →

  4. Help > Contents site is broken

    FYI - http://help.red-gate.com/help/SQLCompare11/help_5.aspx?lang=en fails to load with YSOD

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  5. Make your software work better.

    Used to have SQL Compare on SSMS, went on this morning to find it gone from the menus. Now have to reset the tool in my SSMS menu.

    Went to the SQL Compare help menu to try to figure this out, go to Help / Contents, when I click on this it opens up a web page at the following location - http://help.red-gate.com/help/SQLCompare11/help_4.aspx?lang=en - which is not a valid page - gives me a "Server Error in '/help' Application. - Runtime Error" page.

    What gives?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  Jonathan Watts responded

    Hi there Phil,

    Sorry you experienced an issue with SQL Compare. We hadn’t updated part of the help site after some recent changes. We have just updated and it should be fixed now.

    Many thanks,

    Jonathan Watts

    - SQL Compare Team
    - Software Test Engineer

  6. Bug with compare script when trying to sync constraint names (v11.3.0.7)

    I have table A with named default constraints and a named PK, table B is identical except the defaults and PK do not have a name.

    When I run the deployment script to make table B the same as table A it does not handle the primary key and generates an error:

    Msg 1779, Level 16, State 0, Line 1
    Table 'tableA' already has a primary key defined on it.

    I also note there is a link at the top of the screen to report bug, however when I click it (http://www.red-gate.com/messageboard/viewforum.php?f=154) I get the message "The forum…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  7. Pls ignore constraint names in schema compare. I dont want to ignore the constraint itself just the name

    Pls ignore constraint names in schema compare. I don't want to ignore the constraint itself just the name

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  AdminMichael Upton (Development Lead, Redgate) responded

    This feature already exists – there are two relevant Compare options: Ignore constraint and index names, and Ignore system named constraint and index names. These are described in more detail in http://documentation.red-gate.com/display/SC11/Setting+project+options#Settingprojectoptions-Ignoreconstraintandindexnames

    If this does not work correctly for you, please e-mail support@red-gate.com and let us know what’s going wrong.

  8. filter with underscore in name doesn't work correctly (possible bug)

    When applying a filter with "Starts with underscore" it removes all entries with underscore in the name, even when they underscore is not at the beginning of the name. Please fix. My upgrade scripts missed important stored procedures because of this apparent bug.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  AdminMichael Upton (Development Lead, Redgate) responded

    This problem has been fixed in version 11.2 (currently only available via frequent updates). We have added new ‘Like’ and ‘Not like’ filter match operators which honour all SQL LIKE wildcards, and changed the previous ‘Begins with’, ‘Ends with’, and ‘Contains’ to stop treating them as wildcards.

    You may need to edit existing filters to take advantage of the new behaviour.

  9. Add "use <<Database>>" as an option for the sql

    It would help to have "use <<database>", where <<database>> is the db where you intend to load the sql appear in the object sync script

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Admin →
    completed  ·  Anonymous responded

    We already have an option for this: If you look at the Project Options and choose “Add USE statement” that should do the job!

  10. Bug - Rename Table and Field

    Table tblTableA with field fldFieldA is renamed tblTableB and field fldFieldB.
    Then map tables between two different databases.
    Script snippet generated in renaming field is something like:
    IF (COLLENGTH(N'[dbo].[tblTableA]', N'fldFieldA) IS NOT NULL) AND (COLLENGTH(N'[dbo].[tblTableB]', N'fldFieldB') IS NULL)
    EXEC sp_rename N'[dbo].[tblTableB].[fldFieldA]', N'fldFieldB', N'COLUMN'
    GO
    Obviously I have omitted other script details, but hopefully you get the idea, that this will not work as the table has been renamed.

    Rob

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  Sam Blackburn responded

    Update: It turns out this bug was really easy to fix – we’ve released it to our Frequent updates channel.

    Cheers,
    Sam.

    Hi Rob,

    Thanks for your feedback. I’ve managed to reproduce this issue locally and I’ve logged it with reference number SC-8948.

    I’m going to close this user voice request since this is for a bug rather than a new feature. (We track these in a slightly different way and want to make sure we triage this appropriately). If you’d like to track the progress of this fix please get in contact with our support team by emailing support@red-gate.com.

    Cheers,
    David

1 2 4 Next →
  • Don't see your idea?