Offline and Online database

  • Thread starter Thread starter Rajesh Rajesh
  • Start date Start date
R

Rajesh Rajesh

Hi,
We have an intranet application that is up and running that uses
ASP/VB/SQL Server 2000/IIS.
Now we want this application to be accessed by our mobile sales staff,
who use laptops with replica of the main database(lets call this child).

During working hours our sales staff will input data to the database on
the lap top and in the evening they will synchronize the data to the
intranet database connecting through the network.

Could any one please help me on how do go about doing this? The Web
server/DB Server is behind a firewall and so the laptop database cannot
connect to the database directly.
How do i sync the two databases? not exactly sync, but ideally, what i
am looking for is to transfer only the child data to the parent
database.

Regards
Rajesh
 
Hi Rajesh:

From the sounds of it, you don't need to use Merge Replication with SQL
Server right? If not, then you can just persist your datasets saving the
diffgram (which is just a param in DataSet.WriteXML()) and you could create
a simple web services, that recieves the data and updates the database with
it.

Does this sound viable or do you have to use Replication? If so, it's
probably going to be a little tough with the scenario described.

Bill

www.devbuzz.com
www.knowdotnet.com
 
Back
Top