Activity overview
Latest activity by howarthcd
SQL Compare Bug ? - DB vs VS DB Project - Object Permissions Ignored
I seem to have encountered a possible bug in SQL Compare 14.5.22.19589 Professional whereby permissions are ignored from the comparison when comparing a SQL 2019 DB with a VS DB Project of the same...
Module Signing Support?
Hi, does SQL Compare check databases for differences in relation to module signing?I ask because comparisons between a database and a scripts folder don't appear to have been identifying that a par...
Thanks @Alex B for researching into this and getting back to me. I'm not totally convinced about the explanation though as I've subsequently found that the error only surfaces when there is a 'WITH' clause included with the constraint creation statement, even when the table creation statement is not qualified with the database name. Splitting apart the table and constraint creation script gives the error in this scenario: CREATE TABLE [Logging].[LogEntries] ( [LogEntryId] INT IDENTITY (1, 1) NOT NULL ) GO ALTER TABLE [Logging].[LogEntries] ADD CONSTRAINT [PK_LogEntries] PRIMARY KEY CLUSTERED ([LogEntryId] ASC) WITH (FILLFACTOR = 90) GO
...but not in this one: CREATE TABLE [Logging].[LogEntries] (
[LogEntryId] INT IDENTITY (1, 1) NOT NULL
)
GO
ALTER TABLE [Logging].[LogEntries] ADD
CONSTRAINT [PK_LogEntries] PRIMARY KEY CLUSTERED ([LogEntryId] ASC)
GO
The only difference is the omission of the WITH clause in the second pair of statements. I agree that this is evidently an edge case and so likely isn't worth spending the time on fixing. Thanks again Chris / comments
Thanks @Alex B for researching into this and getting back to me.I'm not totally convinced about the explanation though as I've subsequently found that the error only surfaces when there is a 'WITH'...
Refactor Bug - SQL Prompt 10.1.7.15015
SQL Prompt 10.1.7.15015I've encountered a strange (possibly edge-case) bug when refactoring in either SSMS (v18.5) or VS 2017 Professional (15.9.21) , seemingly when a table belongs to a schema nam...
MS SQL Server Database Projects Not Being Identified
It seems that at some point between SQL Compare 14.1.8.14471 and 14.2 the application has lost the ability to recognise MS SQL Server Database Projects when choosing a script folder, the message "S...
SQL Compare 14 Permissions for Decryption of Encrypted Objects
The documentation at the following page:https://documentation.red-gate.com/sc14/getting-started/requirements/permissions-required-to-use-sql-compare...suggests that objects can be decrypted (SQL 20...
Nested Role Membership Bug?
There seems to be a bug in SQL Compare relating to the parsing of scripts in a script folder and nested role membership where a Windows-based database user (minus the domain name) has the same name...
Website License Summary Page
On the page displaying the summary of licenses by product it would be really useful if the remaining number of invites / remaining activations were shown for each license:https://www.red-gate.com/D...
SQL Compare 13.7 Command Line - Exit Code 126 - SQL Error
Whenever exit code 126 is returned with an output log file configured, the output file does not appear to contain any details of the actual SQL error, making troubleshooting fiddly. The output file...
Error: GrantOrRevoke should have users specified...
Hi, I'm receiving the following error when comparing two Microsoft Database Projects that are contained in script folders:
GrantOrRevoke should have users specified when processing DatabaseLevelObj...