Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-01 : 09:03:47
|
| Joko Waluyo writes "Hi,I have some question for you, this is my problem.I have 3 MS SQL Server in 3 location, each other haveabout 200 km far, but have integrated in one WAN viaVSAT. I want each database server have same data.Database A, B and C.Database A have own data, Database B have own data,Database C no have own data, It receive from databaseA and B. But every Database have the same data,Database A have data from database A and B,Database B have data from database A and B,Database C have data from database A and B,So its need synchronization. Because of low bandwidth,and the data big enough, I want the synchronizationjust the delta of data, no all of data. Is there any software available to solve this problem?I want to know if there's a clue tosynchronize my 3 database each other. Can you explain me ?Thanks" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-01 : 09:12:55
|
| This looks like a job for....REPLICATION!Transactional replication would probably work best for you. I recommend that you look up "replication" in SQL Server Books Online and read as much as you can about it. There are several types of replication and you should be familiar with them all before you start. Transactional replication does exactly what you described, it will synchronize changes between the publishers and subscribers based on the transactions only, not the entire database.There is also a replication section here on SQL Team: http://www.sqlteam.com/FilterTopics.asp?TopicID=101 |
 |
|
|
|
|
|
|
|
Delta Synchronization