Activity overview
Latest activity by jgruber
Hi,
im afraid I didn't actually run the script generated by Data Compare 8, I only checked if it generated the same date strings as Data Compare 7.
I assume version 8 works, sorry for the false alarm! / comments
Hi,
im afraid I didn't actually run the script generated by Data Compare 8, I only checked if it generated the same date strings as Data Compare 7.
I assume version 8 works, sorry for the false alarm!
syncing datetime columns broken on all german servers
The script produces the following line:
UPDATE xxx SET [TMS]='2009-07-30 16:59:18.537' WHERE [ID]=1
which should actually read
UPDATE xxx SET [TMS]=convert(datetime,'2009-07-30 16:59:18.537',121) W...
Changes within function in a calculated column not detected
It seems like Redgate Compare 6.2.0.271 is unable to detect changes within functions in calculated columns (tested on SQL Server 2005).
Here's a test case:
1. On both servers execute
create table d...