SQL servers merge transactions

Tags:
SQL Server 2008
SQL Server database
SQL Server synchronization
SQL Server transaction logs
SQL transaction logs
In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is high and user unable to do data entry job in the application.Then the requiremnt have changed to use local server for branches . after completing data entry work and they want to update to sql server in the web.during that process latest transactions changes from local server have to update in web server, mean time another branch local server will also update to server in web.and local servers have to get exchange data through web server.When user click update button, only todays transactions from local server should update to web server and from web server transactions or other another branch latest data that had already updated have to transfer from web server to local server. What are the possible ways to do this ? could you guide me for this situation?

Software/Hardware used:
Visual Studio 2008,Sql server 2008

Answer Wiki

Thanks. We'll let you know when a new response is added.

What you want to use is the native Merge replication. The users at each branch office will always connect to their local SQL Server instance. When the network is online the branch office SQL Server will update the central database is near real time. When the network is down the changes will be queued and sent automatically when the network is back up.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following