Compares and synchronizes SQL database content.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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.
- 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