SQL Server Performance Forum – Threads Archive

Data Replication between laptop and central server

Hi : My application is a mobile client application where multiple laptops connect to a central server periodically, over VPN. Master data is updated on server and downloaded to all laptops. Transactional data is updated on various laptops and replicated to the central server. Transaction data is user dependant and the data residing on the laptop would depend on it’s user. I had earlier thought of 2-way replication. But this forum suggested that, that would be slow and would involve locking tables which is not acceptable. Instead, it advised me to develop my own code to implement the above requirements. Now I need some guidance along this track…. I would especially like to know if DTS involves table level locking. How feasible would this option then be ? Any help would be greatly appreciated. Thanks !

---

DTS might help to some extent but you need to execute the jobs everytime you connect to the central server and if those are scheduled make sure you have connection between server and client. If the data is not big enough, I don’t see any performance on DTS tasks. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

Thanks Satya, for the quick response. The data that I’m talking abt is abt 8-10 masters.
1 of the master tables has around 20,000 records. All others don’t have as much.
The transactional tables have huge amounts of data. What abt the locking options in DTS ?

---

But you won’t be replicating this data daily right? What is the amount of data transfer that you are looking at? As far as locking is concerned, consider DTS insert as a normal insert and so if the data inserted is huge, we may see large locking else there shouldn’t be a problem. Gaurav

---

For the DTS locking refer to your post for Bambola’s reply http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1048].
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>