Options
Missing Data with ver 4.1.0.29
IronDonut
Posts: 2
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.
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
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.