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