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

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

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

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more