How to distinguish changed data in CSV transferred over FTP using SymmetricDS -
i trying transfer changed data ftp server using symmetricds. and, able transfer successfully. csv file generated contains changed row_data i.e in case of 'update' event, row updated values there , 'insert' event, there row new values. here few points wondering about:-
- how distinguish between 'updated' row , 'inserted' row in csv file?
- also, 'delete' event, there no corresponding row in csv file. so, how fetch rows deleted?
can please me out on one.
if there's row old_data operation
update
, otherwise operationinsert
. not forget on target side symmetricds fallbackupdate
if there's row same primary key though old_data empty, i.e on source node thereinsert
, vice versa.are on_delete triggers declare @ all? easiest check list of defined triggers in db , find out if on_delete present. other way delete row, commit ,
select * sym_data order data_id desc
verifying delete data has been captured ondelete
.
Comments
Post a Comment