Compare tables with only 1 column/row

maxpayne1256

Hello,

I have some tables which only contains the last processed id of another table. Is it possible to compare it with SQL Data Compare?

e.g.:
LastProcessedDataRowId
1293048023

I cant set a comparision key, because then it would duplicate my data, which is not useful.

I know, that i can create a column with PK and identity, but i don't want to change my database only due to comparison reasons.

Rob C

Hi,

When you are selecting the comparison key in "Tables and Views", choose "Custom" from the dropdown box and then pick LastProcessedDataRowid from the list. This will perform the comparison using LastProcessedDataRowid instead of a primary key.

Does this help?

maxpayne1256

Thank you, that's the solution.

I thought that it would keep the value in the target db and insert the value from the source, but the result is only the value from the source db, which is excactly what I wanted.