As we known that CDC can not work on two different servers.
Please try to compare tables to get the updated data then insert it to another DB by manual. For example: t<DB>input(targetDB sqlserver)-->main-->tMap-->t<DB>output(sqlserver) t<DB>input(sourceDB DB2)-->lookup--> Make a inner join and set "Catch Look up inner join reject " as true and the processed data should be updated data, then insert it into another to keep the two database "Sync".
