My issue is:
DB in HK got 3-5 million records/day. I need to replicate an amount of selective records to Canada, which is supposed to be 1-3 million records/day.
Can someone please advise me some possible solution? Acceptable delay is a few minutes, or even 10-20 minutes in the worst case. Even some 3rd party tools is considerable
My current dbms is sql server 2k8 r2
A million thanks to any reply