What are the challenges you face when working across database platforms? Take the survey

How to compare non-nullable Timestamp with Binary(8)

We have two almost identical databases. We have fields called row_version on a number of tables. In one database they are non-nullable Timestamp fields and in the other database they are non-nullable binary(8).

When I try to compare the two SQL Data Compare tells me the Timestamp and binary(8) fields can't be compared because they are incompatible data types.

You can't put a specific value in a timestamp field so I need to be able to copy the timestamp from one database and write the same value into the other database which is why we use binary(8)...but then I have the problem when comparing.

I also have the same problem if I use varbinary.

Is there a datatype that I can write to that can be compared to a timestamp field?


Best Answer


Sign In or Register to comment.