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

Error while comparing: Unkown Type sys.time

I have two databases I want to compare. After some seconds, I get an error: Unkown Type Sys.Time ... Pretty strange. We are using SQL 2008R2 with version 5.4.0.0

facgjpzkegep.png
Ronald Kraijesteijn
0

Comments

3 comments

  • AshaPatel
    Hello,

    I'm sorry to hear you're hitting a problem!

    Have you managed to successfully compare these two databases before you started seeing this error? If so, has anything changed recently in the schema?
    AshaPatel
    0
  • Kraaitje
    Yes it worked before but I cannot see what column is causing the issue. I never heard of data type sys.time :cry:
    Kraaitje
    0
  • AshaPatel
    That's interesting. Do you have any records for checking what has changed in your database schemas since they was last successfully compared? Have any of the column types been changed? I'm thinking maybe it's a time column type (https://docs.microsoft.com/en-us/sql/t-sql/data-types/time-transact-sql) that isn't being handled properly, which would also explain why you're seeing the error on the 'Remap Objects' tab.

    As an alternative, is it possible for you to upgrade to the latest Data Compare version? We are now on version 13.1.1; version 5.4.0.0 of Data Compare is over 10 years old. There have been a lot of improvements throughout the later versions which may have already handled the issue you are seeing.
    AshaPatel
    0

Add comment

Please sign in to leave a comment.