0

I have let’s say 3 local database instances deployed at 3 different geographical locations around the world.
I want to sync all these three local instances to one central instance deployed at yet another geographical location.
I am looking for only one-way sync; from Local to Central. Finally, central instance will have data from all three local instances.

Database structure of all the databases involved is exactly the same.
Each local instance and the central instance are connected through internet; other necessary security is implemented and connectivity is available.
If this is real-time, that will be great. But, if this causes some lag or delay, let's say an hour or so, that can be acceptable.

I cannot use MS SQL Server's Replication feature as the connectivity will not be consistent. Connectivity may not be available for hours in some cases. As per my understanding and previous experience with Replication feature, this causes many problems and also need manual involvement to take the things on the track again. I have read this. In general, Replication is not suitable in my scenario.

Is there any other way to sync local and central instances?

Improve this question
6
  • Will each local instance be syncing different tables to the centralized instance, or they have the same tables and will be writing to the same centralized tables during synchronization? Commented Jan 29 at 13:46
  • @J.D.: Database structure of all the databases involved is same. The same tables will be synced. Commented Jan 29 at 14:20
  • To clarify, TableAbc at the central instance will have all the records from LocalInstance1.TableAbc + LocalInstance2.TableAbc +LocalInstance3.TableAbc, all in a single table at the central instance right? Commented Jan 29 at 20:02
  • 1
    It's unclear from your question why SQL Server Merge Replication would not work, so it's impossible to suggest alternatives. Commented Jan 29 at 20:22
  • @DavidBrowne-Microsoft: I have edited the question to answer your comment. Please review. Commented Jan 30 at 7:20

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.