Hi,

I have the following scenerio:
DB-1 (at Pheonix)- Main DB
DB-2 (NY)- Data comes from all the other locations and get loaded on intermittently.

I need to replicate the data load that happens on DB-2 to DB-1. At the end of dataload to DB-2, it looks similar to DB-1, but some of the values would have changed.

It's a one way replication.My question is

1) What time of replication is required?

2) Will all the records gets replicated or only the ones that gets changed get replicated.

3) Some records on the DB-2 would be deleted,and I need the same record on the DB-1 to be deleted too. Hope this will be handled by replicator.

4) If in a record is inserted in database -DB-2 and is same as the one in DB-1, will that still get replicated and there by hogging the network bandwidth.


Badrinath