You need to setup a comparison that uses mapping to compare Table1 to Table2 in the same database. Then you can exclude all the columns that you don't want to move from the comparison.
If the only column you are left with is the column you are using as a comparison key that should work. Although you will be generating insert statements that contain only that one column - as long as the rest of your columns have defaults this should be fine otherwise you'll have to compare all the columns (assuming they match) or set defaults for the columns not included in the comparison.
yaip
Posts: 4
Comments
If the only column you are left with is the column you are using as a comparison key that should work. Although you will be generating insert statements that contain only that one column - as long as the rest of your columns have defaults this should be fine otherwise you'll have to compare all the columns (assuming they match) or set defaults for the columns not included in the comparison.
HTH
Project Manager
Red Gate Software Ltd