How can we help you today? How can we help you today?

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

Edit: this was tested on version 7.0.0.559 and 8.0.1.9
jgruber
0

Comments

2 comments

Sort by
  • 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.
    Chris Auckland
    0
  • 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!
    jgruber
    0

Add comment

Please sign in to leave a comment.