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:-

  1. how distinguish between 'updated' row , 'inserted' row in csv file?
  2. also, 'delete' event, there no corresponding row in csv file. so, how fetch rows deleted?

can please me out on one.

  1. if there's row old_data operation update, otherwise operation insert. not forget on target side symmetricds fallback update if there's row same primary key though old_data empty, i.e on source node there insert , vice versa.

  2. 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 on delete.


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -