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

Missing Data with ver 4.1.0.29

IronDonutIronDonut Posts: 2
edited April 5, 2006 12:40PM in SQL Compare Previous Versions
Hi everyone,

I've noticed a problem where SQL Data Compare skips the data in some of my tables. Typically these will be 'connector' type tables with no primary key and two foreign keys that connect two other tables.

Anyone else run into this problem or know of a fix?

Thank you.

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    You would need to upgrade to v5, which lets you specify a column to use to match records. Otherwise, v4 requires a primary key as assurance that the column data is all unique.
Sign In or Register to comment.