Posts
Sort by recent activity
Add object existence checks option is preventing ALTER
When "Add object existence checks" is checked the generated script fails to perform alter's. Note the generated script below only executes the alter if the object does not exist.PRINT N'Altering [...
Security warning when running SQL Data Compare 7.1.0.245
I get a warning from Trend Micro Systems when running SQL Data Compare that RedGate.SQLDataCompare.UI.exe is trying to change my system settings. It's labeled a high risk attempt at Program Librar...
Script folder comparison doesn't work for non-dbo schema
Tables and stored procedures in a non-dbo schema are not being categorized as either different or identical when comparing a script folder to a database. Instead they show as both existing only in...
synchronize certificate permissions
We use certificate signatures on a handfull of stored procs that use dynamic SQL. The signature allows select/update access to the tables; otherwise users only have rights to execute the stored p...
Data Compare fails with DateTime msg when comparing bak file
When attempting to use SQL Data Compare t to compare a live database with a recent backup file of the same database, the following message is produced:
"The DateTime represented by the string is no...