Two SQL server synchronization

Tags:
.NET
SQL
SQL Server
SQL Server synchronization
VB.NET
How can I merge two SQL Server databases?

One sql server is in web  and another in local machine 

both sql servers will have daily data transactions entries.

how to merge those daily data transactions between the two sql server?

 i am new to sql synchronization and merging.

could you kind enough to help me?



Software/Hardware used:
vb.net based windows application

Answer Wiki

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

OK, 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: 2  Replies

 
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
  • Qqqqqqqqqqqqqqqqqqqq
    Ok fine i would like to explain requirements in detail. 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?
    20 pointsBadges:
    report
  • Qqqqqqqqqqqqqqqqqqqq
    [...] 8. Mrdenny to the rescue of a member wondering about two SQL server synchronization. [...]
    0 pointsBadges:
    report

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