syncing datetime columns broken on all german servers

jgruber

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) WHERE [ID]=1

Edit: this was tested on version 7.0.0.559 and 8.0.1.9

Chris Auckland

Thanks for your post.

Does the script generated in SQL Data Compare 8 fail on your German servers?

The reason I ask is because in SQL Data Compare 8 we added a line to the top of the script to set the date format, so that a difference in a servers date format wouldn't break the script.

We now add the line:
SET DATEFORMAT YMD
GO

The incorrect date format was a a known issue in version 7, but it shouldn't be a problem now in v8.

I hope this helps.

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!