Posts
Sort by recent activity
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...
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...
Script File Encoding Ignored
I've just upgraded to SQL Compare 11.0.0.365 and have found that when comparing a Database with a Scripts Folder I am finding that the ScriptFileEncoding value is being ignored when the value is se...