syncing datetime columns broken on all german servers

jgruberjgruber Posts: 5
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 and


  • 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:

    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.
  • 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!
Sign In or Register to comment.