Help get this topic noticed by sharing it on
Twitter,
Facebook, or email.


dbamp replicate w pkchunk or sf_refresh question
If a large amount of updates occur does dbamp do a delete then insert or update?
-
Replicate is a full backup, meaning it copies down all rows and all columns of an object. Refresh is an incremental backup, meaning it updates the local table with any rows that have changed (deleted, inserted, updated) since the last refresh or replicate.
-
-
but do the records that need to be updated actually get updated? Or are they actually deleted and reinserted?
-
-
If running a Replicate the records are loaded into a work table and then renamed the actual table. In a Refresh the records that are to updated, are deleted and then reinserted from a table that contains the delta records.
-