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

I have 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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
I would use a local database and replication.
vensaliAuthor Commented:
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.
ste5anSenior DeveloperCommented:
Replication handles the transfer. You need only your own service to handle the connectivity issus.

btw, you may also take a look at the Sync Framework.
And Learn Microsoft Sync Framework.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vensaliAuthor Commented:
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.


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

Tab2  - Hospno 2 --            row1


   Win2008 server with sql2008r2

    Hospno1               row1

   Hospno2               row1

What is the ideal replication configuration in this scenario
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.