SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 03:10 AM
| |||
| |||
 Re: Is there some application can help export only the changed datafrom DB2 ? richard wrote: > I need export only the changed data (updated or deleted or inserted) into Oracle. > Any suggestion? > Thanks Information Integrator can handle the replication, I think.      |
|
02-27-2008, 03:10 AM
| ||||
| ||||
| Re: Is there some application can help export only the changed data from DB2 ? There are quite a few different approaches to this problem - if you're using, or consider using an ETL tool then your vendor should hopefully have a solution for changed data capture. Otherwise, it isn't too difficult to do on your own. If you need transaction-level detail, and really do need deletes: have the application or triggers also write transactions to a change history table, then extract from this (based on row timestamps > than last extract) If you only need snapshots, then the easiest solution can be a 'file-image delta': in which you export the table to a flat file, sort it, and compare it to the last export. The output of this process is typically a set of five files: new rows, deleted rows, same rows, updated-new rows, and updated-old rows. Although I prefer to use a utility that takes a config file for this, you could also run this completely in db2. Instead of exporting, just copy data to another table, then use queries in place of a utility. The nice thing about an 'image delta' process is that it's immune to inaccuracies caused by non-logged changes to the tables. ken |
Linear Mode
