Error while comparing: Unkown Type sys.time

• 
  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 October 30, 2017 16:28

  - 0 +
• 
  Yes it worked before but I cannot see what column is causing the issue. I never heard of data type sys.time

  Kraaitje October 31, 2017 13:01

  - 0 +
• 
  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 October 31, 2017 13:24

  - 0 +

Add comment

Please sign in to leave a comment.