Avatar of vensali
vensali
Flag for India asked on

saving data in temporary file and transferring it to db when network connectivity is avialable

I have vb.net application running on windows 8 tab,  Requirement is, doctor enters the investigation advised in a tab while going to rounds for a patient which has to be saved to temporary file.( this is because, some places wi connectivity may not be available).

When the connectivity is established, the data saved in file should get automatically  transferred to the DB in the background.

How to achieve this result.
Visual Basic.NET

Avatar of undefined
Last Comment
vensali

8/22/2022 - Mon
ste5an

I would use a local database and replication.
vensali

ASKER
how to handle the connectivity issue between local db and production DB.  can it be automated? I,e   a background process will keep checking the connectivity between the two dbs and when the connection is established, it automatically replicates the data.
ASKER CERTIFIED SOLUTION
ste5an

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
vensali

ASKER
As i see the typical set up in my case would be as mentioned below,

I have multiple tabs  (win 8) with sql server 2008r2 std edition installed. Each instance of the tab  will be configured as publisher.  i have one server configured as distrubutor  and  one server configured as subscriber.   the data is captured in each of the tab will be consolidated in the subscriber sql instance.


publisher

Tab 1   - Hosp no 1 --        row 1
                                             row 2

Tab2  - Hospno 2 --            row1
                                             row2


Subscriber

   Win2008 server with sql2008r2

    Hospno1               row1
                                   row2

   Hospno2               row1
                                  row2



What is the ideal replication configuration in this scenario
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy