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

Problems with DateTime Columns

I have created a copy of my database-structure using SQL Compare.

Now I want to synchronize some table data using SQL Data Compare and here I get some errors:

If a table has a column with datatype datetime, the synchronization isn't working properly. (datetime format is dd.mm.yyyy hh:mm:ss.nnn)
If I try to synchronize, SQL Data Compare tries to insert the values into the new database in the format mm.dd.yyyy hh:mm:ss.nnn and so there are some records that cause an error.

How can I prevent this error without loosing the data?

wbr

RolandE


PS: Both databases have the same collation and are on the same server.
RolandE
0

Comments

2 comments

Sort by
  • SSW
    We have the same problem. It seems so, that the localization issues of date(time)-datatypes have not been considered.

    Workaround: Transfer the synchronisation script to the SQL Management Studio and add the following line before it.
    SET LANGUAGE us_english
GO

    With big amounts of data it's not so easy... but it works...

    Hopefully this bug will be fixed soon...
    SSW
    0
  • Michelle T
    Yes, we have a problem with datetime localisation :oops: . We're working on fixing it.
    Michelle T
    0

Add comment

Please sign in to leave a comment.