| Author |
Topic |
|
pdnx
Starting Member
3 Posts |
 Posted - 2012-07-13 : 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 considerableMy current dbms is sql server 2k8 r2Sorry if I'm in wrong roomA million thanks to any reply |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdnx
Starting Member
3 Posts |
Posted - 2012-07-15 : 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
38200 Posts |
|
|
pdnx
Starting Member
3 Posts |
Posted - 2012-07-15 : 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
38200 Posts |
|
|
dolphin123
Yak Posting Veteran
84 Posts |
Posted - 2012-07-17 : 16:19:30
|
| Just curious - How did you find out the percent of your writes on a database? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
How to replicate data to a remote place