February 21, 2014 at 6:27 am
Hi Experts,
We have our OLTP VLDB ,the database contains all information about clients from different countries .Now we have a plan to move data related to particular to servers in that country . The new DB in that country is used mainly for reporting purpose only ,ie the mail database will still get the data and will be replicated from here to other db in other countries.
How can we achieve this with maximum allowed latency of 10mins??
How can we split the data from the main db based on different country to different db?
Thanks in Advance.
February 21, 2014 at 8:52 am
There's no way answer what you are asking in a few sentences or a post. Latency will depend on the load you're moving across links and the bandwidth. You need to measure what you're getting, and probably get help from a paid consultant on specifying the links and capacity you need.
In terms of moving data to new databases, if you have some sort of ID or marker per country, you can easily partition the data being sent across replication by specifying a filter for the publication. http://technet.microsoft.com/en-us/library/ms151775.aspx
February 21, 2014 at 10:44 am
Wow..reply from Steve..
Thanks a lot Steve
February 21, 2014 at 11:11 am
You are welcome.
good luck
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply