TableDiff.exe - Unable to create UPDATE message

  • Hello,

    I have written a script to compare and script table differences by calling the tablediff.exe.

    I noticed that some tables return the following error:-

    The differences I have found, occur when checking columns with a REAL data type.

    The values in each table are different, but most of the precision is correct.

    Is there anyway of getting around this issue?

    Thanks for any help

    Paul

  • The error message did not appear in the previous post, it is -

    unable to create UPDATE for record with only large data types

  • Anyone have any thought on this? 😀

  • I'm experiencing the same issues as well. My tables do not contain any large data types either. The table has only two rows and both are of type INT:

    unable to create UPDATE for record with only large data types

    Anyone have any thoughts?

    snewman

  • I realize this is an ancient post, but for anyone stumbling in here, my issue was that it could not create the sql because the only diff was caps vs lowercase. Cheers.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply