69 results found
-
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
-
Open script with SSMS2012, there is no option yet?
There is no option to choose to open with ssms2012 in the dialog that is shown for deployment, i can choose ssms2008 but not 2012. Is this available somewhere?
8 votesSupport for SSMS 2012 was added in version 10. Version 11 has added support for SSMS 2014.
-
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.
-
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.
-
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
-
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.
-
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?
- Don't see your idea?