Problems with DateTime Columns
RolandE
Posts: 2
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.
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.
Comments
Workaround: Transfer the synchronisation script to the SQL Management Studio and add the following line before it.
With big amounts of data it's not so easy... but it works...
Hopefully this bug will be fixed soon...
Redgate Software