Solved

Database replication best way

Posted on 2004-10-06
3
247 Views
Last Modified: 2010-04-17
Hi Experts,

We are developing an application on asp.net with sql server as a backend. Let me explain what this application is.

This application is for curomer spport management. Company is having various dealers at various location accross the country.


Now the company want to give an offline application to each dealer as well as online access. As the internet connectivity is poor so idea is that each dealer will work offline and then at the end of the day they will uplaod the data back to main  server.

This offline package has been developed in VB.net, sql server as a backend.

As the logistic and other approval officers are sitting at the head office so they update the complaints status and when the next day user log in he pull back the updated data from the main server.

My question is what will be the best way to achieve this. I mean your ideas. How we have to proceed.

Both the online as well as offline package is ready. Please help me, I donot mind to give points. I need best suggestions.

Regards,

loveneesh Bansal
0
Comment
Question by:loveneesh_bansal
3 Comments
 
LVL 3

Accepted Solution

by:
domj earned 125 total points
Comment Utility
A method which is quite often employed is snychronisation through email or distributed text files. Basically you flag any data that is changed in the db and then extract this information at specific times by exporting data from the db based on the modified flag. the method of transport can be anything, most often encrypted data via email, ftp or the like. then at the other end you use this information to update/append the data into the master db.  depending on how complicated you wanted to get, you could whip up a "comms" client and server app without too much trouble to do this for you.

Dom
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
hasOne  challenge 59 87
wordmultiple challenge 12 89
Installed softare without GUID 6 53
PHP question(s) about order of output 9 38
This is an explanation of a simple data model to help parse a JSON feed
This is about my first experience with programming Arduino.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now