Hi Winan,

I am going to start with some questions.

Do you need real time replication or periodic?
Do you need to replicate from head office to Branch A or B…?
Do you need to replicate from Branch A to B or C…?
Is it possible that a user at head office will change a row that also will be changed at one of the branches?
Do you need to have any of the data partitioned? For example, some data from A will go to C but not B,D, or E?

These are just a few of the questions you need to answer before starting on a replication project. Once you have these questions answered, can then start planning how to create the replication rules that the databases use to move the data around.

I have used both MS Sql Server and Sybase SQL Anywhere for replication and I much prefer the Sybase product. The answers to the above questions will greatly effect the choice of product.

Hope this helps


>Dear Expert,
>
>I am very new to replication, I need to replicate my DB on 5
>branches into 1 DB at Head Office.
>
>eg.
>
>MyDB at Branch A need to be replicated to MyDB at Head Office
>MyDB at Branch B need to be replicated to MyDB at Head Office
>MyDB at Branch C need to be replicated to MyDB at Head Office
>MyDB at Branch D need to be replicated to MyDB at Head Office
>MyDB at Branch E need to be replicated to MyDB at Head Office
>
>FYI, every table has Branch Id, so it won't be duplicate record!
>
>I really need advise .. how to do such replication .
>
>Any prompt reply would be appreciated ! .. Thanks a lot in advance
>
>Regards
>
>Winanjaya