Activity overview
Latest activity by dschaeff
Yes, I am fine using V10. / comments
Yes, I am fine using V10.
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...
Thanks Simon for your reply. After scripting the schema into a file into my scripts folder SQL Compare worked like a charm. This allows me to determine what source code as maintained in our source control system (Team Systems) is out of whack with our database. The answer is an alarming amount. Now to reconcile these differences... / comments
Thanks Simon for your reply. After scripting the schema into a file into my scripts folder SQL Compare worked like a charm. This allows me to determine what source code as maintained in our sourc...
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...