70 results found
-
CREATE QUEUE [dbo].[Applicati
Support the POISONMESSAGEHANDLING argument for service broker queues.
/****** Object: ServiceQueue [dbo].[ApplicationLogSendingQueue] Script Date: 03/15/2012 11:34:56 ******/
CREATE QUEUE [dbo].[ApplicationLogSendingQueue]
WITH
STATUS = ON ,
RETENTION = OFF ,
POISONMESSAGEHANDLING (STATUS = OFF) ON [PRIMARY]
GO5 votesThe latest release of SQL Compare contains support for this syntax.
-
Allow SQL Compare to ignore name differences in Default Constraints
Since default constraint names are system generated, they may have the same defintion but a different name.
22 votesThe ‘Ignore System named constraint and index names’ option should address this issue, unless I’ve misunderstood?
-
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 voteWe already have an option for this: If you look at the Project Options and choose “Add USE statement” that should do the job!
-
Additional filtering so that permissions changes on objects can be ignored.
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 votesThe ‘Ignore Permissions’ option (Options→Ignore→Permissions) should do this. If it’s not working for you, please e-mail support@red-gate.com
If you need more granular ignore options, please feel free to add a new uservoice suggestion with the details.
-
Support "Ignore Column Order" in comparison window
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 votesWe have completed this as part of https://documentation.red-gate.com/display/SC12/SQL+Compare+12.4+release+notes
-
BUG: IF condition backward for sp_rename !!
Here's an entire deployment script. Can you spot the bug?
SET NUMERICROUNDABORT OFF
GO
SET ANSIPADDING, ANSIWARNINGS, CONCATNULLYIELDSNULL, ARITHABORT, QUOTEDIDENTIFIER, ANSINULLS ON
GO
USE [MVSDB]
GO
PRINT N'Altering [dbo].[Shift]'
GO
IF (COLLENGTH(N'[dbo].[Shift]', N'ShiftDefinitionId') IS NOT NULL) AND (COLLENGTH(N'[dbo].[Shift]', N'ShiftConfigurationId') IS NULL)
EXEC sprename 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 votesThis was fixed in version 10.0.0.179
-
MsSql Server 2008 R2
Support MSSQL Sever 2008 R2 and Management studio 2008 R2. (will remove datetime2 warnings
4 votesSQL Compare does support SQL Server 2008R2. If you are having specific problems with the 2008R2 support, please e-mail support@red-gate.com
-
Add line comparison at the bottom of the object comparison pane
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 votesSQL 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?
-
Format compare using SQL Prompt format
Ability to format the source and destination code to ensure compare is using the same structure.
157 votesIn SQL Compare v14.7, we've added a SQL Prompt view tab on the differences pane. We hope this helps you understand actual differences and not just differences due to formatting.
You can learn more at https://documentation.red-gate.com/sc/reviewing-the-comparison-results/viewing-the-sql-differences.
-
64-Bit Version
Create a 64-bit version of SQL Compare.
21 votesVersion 11.2.2.23 of SQL Compare and SQL Data Compare (currently available via frequent updates) will now run as 64 bit processes in a 64 bit environment.
See http://documentation.red-gate.com/display/SC11/Turning+on+Frequent+Updates for details on how to enable Frequent Updates, and http://documentation.red-gate.com/display/SC11/SQL+Compare+11.2+release+notes for the latest release notes.
- Don't see your idea?