question

ramesh 1 avatar image
ramesh 1 asked

transferring data from server to laptops

hi team, we have a DEMODB server and 18 laptops, i want reflect the database changes written to the laptops, following these rules. 1.laptops are not available in a periodic manner. 2.laptop user has no responsibility to update the data as this is a DA's job to update it. availability i assume; 1. pull subscription can be implemented to update the data when in laptop comes online. 2. just make a back up job to copy the differential backup to the laptop folder , then create a batch file to restore the data. please sugggest me any other changes to be done.
sql-server-2008replicationexport-data
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
You could try one of the following: - Snapshot Replication (similar to a full backup being created and restored on the target system) - Merge Replicaiton (if the laptops perform writes that should be uploaded to the central system) - Transactional Replication (be careful of subscription expiration) - Write your own bulk loading tool (using .Net or SSIS or bcp or....) **EDIT: I Misread ramesh's question - here is my revised recommendation:** I recommend Merge Replication for this. The laptops will be able to upload their changes when they connect to the server - this can be done by starting an agent job when the connection is established (it is possible to do this through .Net too). **EDIT End** Writing a bulk loader may be viable if it is just a couple of tables and you have an aversion to replication (some people just don't like it).
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ramesh 1 avatar image ramesh 1 commented ·
but the laptops belongs to the sales people,they my switch it off when they are out of work. we are planning to generate a script which continuously pings , if the ip is available , it immediatley fires s email. requesting for upadate. id the user says YES,then it should update
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
Have you thought of offering an update button on the sales laptops? The user knows when they are online and can then run an update. Is this an update from the laptop to server, or server to laptop?
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Based on everything described, I'd go either with Merge Replication, like @WilliamD says, or look into possibly implementing BizTalk. With BizTalk you could treat the data in the laptops as part of an extended transaction. That would allow for the intermittent connection. It'd take a bit of work, but almost anything you do in this realm is going to take a bit of work.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
@Grant - re-reading what ramesh wrote and your response, I think I misunderstood. If the laptops are doing the data updates and this should be sent to the central server, then I agree that Merge Replication would be the most viable. BizTalk seems to be a big messy XML-parsing machine - quite cumbersome and not as good as it was marketed to be. I have not had much chance to play with it, so I can't say how well that would work.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Biztalk is a big messy XML-parsing machine... just so happens it'll do this work too. We use it for almost precisely this mechanism where I work. It's not easy or fun to work with (like merge replication is, hoo boy) but it will do the job.
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
Merge Replication is a bit of a pain - but if the laptops are working on their own slices of the data pie it should be a breeze.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.