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

69 results found

  1. Since default constraint names are system generated, they may have the same defintion but a different name.

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Michelle Taylor responded

    The ‘Ignore System named constraint and index names’ option should address this issue, unless I’ve misunderstood?

  2. 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)
    You have left! (?) (thinking…)
    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!

  3. Add an option to the filtering so that different aspects of objects can be ignored, e.g. ability to to ignore different permissions on an object.

    We have one database that has permissions set individually on objects, and another database with the 'same' objects, but they don't have any explicit permissions set, but SQL Compare consideres them different, so we currently have ~1700 objects with differences that are only 'user x has y permissions on this object'.

    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 →
  4. If the only difference between two tables is column order, the the table shows under Identical Objects section. But if column order AND something else is different, the comparison window hilights the out-of-order column.

    170 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  5. Here's an entire deployment script. Can you spot the bug?

    SET NUMERICROUNDABORT OFF
    GO
    SET ANSI
    PADDING, ANSIWARNINGS, CONCATNULLYIELDSNULL, ARITHABORT, QUOTEDIDENTIFIER, ANSINULLS ON
    GO
    USE [MVSDB]
    GO
    PRINT N'Altering [dbo].[Shift]'
    GO
    IF (COL
    LENGTH(N'[dbo].[Shift]', N'ShiftDefinitionId') IS NOT NULL) AND (COLLENGTH(N'[dbo].[Shift]', N'ShiftConfigurationId') IS NULL)
    EXEC sp
    rename N'[dbo].[Shift].[ShiftConfigurationId]', N'ShiftDefinitionId', 'COLUMN'
    GO
    PRINT N'Adding foreign keys to [dbo].[Shift]'
    GO
    IF NOT EXISTS (SELECT 1 FROM sys.foreignkeys WHERE objectid = OBJECTID(N'[dbo].[FKShiftShiftDefinition]', 'F') AND parentobjectid = OBJECTID(N'[dbo].[Shift]', 'U'))
    ALTER TABLE [dbo].[Shift] ADD CONSTRAINT [FKShiftShiftDefinition] FOREIGN…

    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 →
  6. Support MSSQL Sever 2008 R2 and Management studio 2008 R2. (will remove datetime2 warnings

    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 →
  7. In the excellent file comparison tool Beyond Compare from Scooter Software, there is a full width line comparison view across the bottom of both comparison panes. This is extremely useful when comparing long lines of text and saves scrolling left and right all the time.

    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 →
    completed  ·  Anonymous responded

    SQL Compare does have this functionality: If you click on the Show dropdown (just above the differences pane), and select Line Differences. Is this the behaviour you were looking for?

  8. Ability to format the source and destination code to ensure compare is using the same structure.

    157 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  9. Create a 64-bit version of SQL Compare.

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
1 2 4 Next →
  • Don't see your idea?