I searched the web sites for advice but came up short on something that looked like what I need. I need to "replicate" a few tables nightly (2am-6am). Each table will have about 1 million new records (~100B each, ~5/second) each day. I have tried using something like a cron job (copy from/copy to) but it has limitiations as far as handling duplicate keys (just need to replace) and it will not fill in gaps if there happen to be any. the servers are also far from each other and only have a 50 KB/s ipsec link between them so data transfer needs to be somewhat minimized. thanks for any suggestions, gene
