source db: has table/s
destination Db : is where data is getting archived
Dest Db: should be setup
using DB utils :+1:
[ ] ilpurge.getTabBySchema("UNIPROD", "UNIPROD"); where 1st param is source Db schema; 2nd param is destination schema which could be in different server/ diff database flavor
dest db schema.
See properties: SRC.DB.URLDES.DB.URLUse threads and batch update:
loop thru rows that need to be deleted
add batchSize see variable DES.DB.BATCH.SIZE=2000
create a thread(set thread count paramter) and execute;note if there is a self join need sp :thinking:
t1 = new ithread(ibatch + "", strInsSql, url);
Same thread should delete data. :thought_balloon:
Should set only threads per table otherwise FK might throw errors.
Store thread info as well. this might be helpful for debugging
[ ] destination table's data should not be present in source table.
[ ] destination table's data should not be present in source table.
source db: has table/s destination Db : is where data is getting archived Dest Db: should be setup using DB utils :+1:
ilpurge.getTabBySchema("UNIPROD", "UNIPROD");
where 1st param is source Db schema; 2nd param is destination schema which could be in different server/ diff database flavordest db schema. See properties:
SRC.DB.URL
DES.DB.URL
Use threads and batch update:DES.DB.BATCH.SIZE=2000
t1 = new ithread(ibatch + "", strInsSql, url);
Should set only threads per table otherwise FK might throw errors.