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.