Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MIgrating Data(Sharding) Expand / Collapse
Author
Message
Posted Friday, February 21, 2014 6:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
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.
Post #1543945
Posted Friday, February 21, 2014 8:52 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:38 PM
Points: 31,368, Visits: 15,834
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1544056
Posted Friday, February 21, 2014 10:44 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
Wow..reply from Steve..

Thanks a lot Steve
Post #1544128
Posted Friday, February 21, 2014 11:11 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:38 PM
Points: 31,368, Visits: 15,834
You are welcome.

good luck







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1544139
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse