Synchronize 2 tables in with only 'INSERT & UPDATE'
yslow
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.
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.