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

Synchronize 2 tables in with only 'INSERT & UPDATE'

yslowyslow Posts: 4
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.
Sign In or Register to comment.