Activity overview
Latest activity by jamal
Specify the subfolder where objects are scripted when creating scripts folders from a database
A long time ago, we scripted our databases to scripts folders to add them to source control. At the time, we told sql compare to put table triggers in their own folder and it did. Our folder stru...
Hi @Peter_Laws - after enabling Frequent Updates, I was able to update to this version. I can confirm this version, 15.0.5.23181, solved the issues I noted in this thread for both Sql Compare and Sql Data Compare. Thank you! / comments
Hi @Peter_Laws - after enabling Frequent Updates, I was able to update to this version. I can confirm this version, 15.0.5.23181, solved the issues I noted in this thread for both Sql Compare and ...
Looks like 14.8 may have been the first version where this bug was introduced. I'm going to try 14.7 eventually. https://documentation.red-gate.com/sc14/release-notes-and-other-versions/sql-compare-14-7-release-notes 14.8.0.21190 - Jun 14th, 2022 FREQUENT UPDATES RELEASE Features
Setting an Application ID is no longer needed to connect using Azure Active Directory Universal with MFA authentication
/ comments
Looks like 14.8 may have been the first version where this bug was introduced. I'm going to try 14.7 eventually.https://documentation.red-gate.com/sc14/release-notes-and-other-versions/sql-compare...
Hi, glad others see it too. Please let me know if you get anything useful from redgate support! / comments
Hi, glad others see it too. Please let me know if you get anything useful from redgate support!
How do I filter out tables from data compare for a sql azure managed database?
Hi, I'm comparing a local db to a version of it in an Azure sql managed instance. Normally, when I run data compare on two databases, I can click the 'Tables & Views' tab to select only the tables...
Hi, this is a pretty old thread, but I ran into the same issue for specific extended properties that were not excluded by the standard extended prop. ignore option. To ignore extended properties sp_addextendedproperty N'sys_sensitivity_label_name' - I found the option by editing the project and checking "Ignore sensitivity classifications". Hope this works for you, though I doubt it's still an issue this far out! / comments
Hi, this is a pretty old thread, but I ran into the same issue for specific extended properties that were not excluded by the standard extended prop. ignore option. To ignore extended properties s...
hi, I experienced the same behavior.
upgraded sql search from v2.x to 3.x (also within SSMS14)
rebooted
sql search displayed no results no matter what search I attempted (a very different behavior than in the past - I've used this for many years).
I uninstalled sql search
I upgraded sql prompt from 9.0 ish to 9.5.23
I reinstalled sql search 3.2.1
Sql search now returns results
One thing I noticed, when upgrading from sql search 2, the installer placed sql search 3 content into the sql search 2 path. When I reinstalled sql search 3 from scratch, it placed its content into the sql search 3 path. I'm not sure if this is the/part of the issue or not. Sorry I did not keep better track of version numbers.
/ comments
hi, I experienced the same behavior.
upgraded sql search from v2.x to 3.x (also within SSMS14)
rebooted
sql search displayed no results no matter what search I attempted (a very different beha...
Sql compare 13 flags GRANT EXEC as different than GRANT EXECUTE
I noticed the only difference in a stored procedure script that was being flagged by Sql Compare 13.1.11.5591 as different between the script and the server was EXEC vs EXECUTE in a grant statement...
BUG: Sql compare 13 flags GRANT EXEC as different than GRANT EXECUTE
I noticed the only difference in a stored procedure script that was being flagged by Sql Compare 13.1.11.5591 as different between the script and the server was EXEC vs EXECUTE in a grant statement...
"The path must be an empty folder" error
Maybe I'm missing something (quite likely) but isn't it possible to link sql source control 3 to an existing set of scripts? We've been using TFS and Sql Compare 9 to source control our database s...