Synchronize 2 tables in with only 'INSERT & UPDATE'

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Synchronize 2 tables in with only 'INSERT & UPDATE'

Postby yslow » Tue Oct 22, 2013 8:46 am

Hi all,

I have 2 tables in different database of different servers.

Source : Table A contains 45 records.

Destination : Table B contains 100 records.

I would like to sync Table B where :

update Table B according to Table A.
Insert to Table B if Table A has new records.
DO NOT delete records who exist in Table B(destination) but do not exist in TableA(source)

In this case, only INSERT & UPDATE to table B is needed.
Please advise about the configuration in excluding the deletion happens on Table B.

Thanks in advance.
yslow
 
Posts: 3
Joined: Tue Oct 22, 2013 8:37 am

Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests