| Author |
 Topic  |
|
|
pdnx
Starting Member
3 Posts |
 Posted - 07/13/2012 : 05:36:35
|
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
Sorry if I'm in wrong room
A million thanks to any reply
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
pdnx
Starting Member
3 Posts |
Posted - 07/15/2012 : 21:34:08
|
quote:
Originally posted by tkizer
What's wrong with transactional replication? Have you tested your network latency?
Tara Kizer
I don't know if with transaction replication, I can replicate only selective rows.
As I know can only replicate on selective columns, not row, I don't want to replicate all rows |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
pdnx
Starting Member
3 Posts |
Posted - 07/15/2012 : 23:02:25
|
quote:
Originally posted by tkizer
Yes you can replicate "selective rows" with transactional replication. Use the filtering option.
Thanks for your information, I'll study how.
I still have one concern is the latency, from my view, it's very hard to get such amount of transaction to be replicated well outside LAN connection, please advise |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
dolphin123
Starting Member
USA
44 Posts |
Posted - 07/17/2012 : 16:19:30
|
| Just curious - How did you find out the percent of your writes on a database? |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
How to replicate data to a remote place
