| Peter Nolan 2005-07-08, 11:23 am |
| Hi Scott,
the is seems it is the case that you have one database being updated
and you want a copy of it elsewhere.......
If you have no other way of getting the changed rows (application,
timestamps, log reader, whatever) you can try out our delta generation
utility, we wrote it for a client who had a similar problem......no way
of getting the deltas from the operational system.
It dumps tables and then performs a field my field comparison to see if
a row has changed based on a key defined for the row. I prefer field
by field to CRC because there is always a chance a CRC will return a
false negative...no matter how small.
It's 'brute force' but doing delta generation in files is an order of
magnitude faster than doing them in a database........once you have
generated the deltas you can just send the delta files to your target
server and run the deltas against the target server.....this way you
only transmit the deltas and only perform the number of updates you
need to perform to apply deltas......the 'cost' being the generation of
the deltas in the first place....the software for this is free and
'open source' in that you can download the program source code but not
the classes called by the programs...
Best Regards
Peter Nolan
www.peternolan.com
|