Solved

SQL DB copy on web as central copy

Posted on 2013-11-21
1
152 Views
Last Modified: 2013-11-25
Hi,

I have a requirement and need to understand best options for that.

I am working on a desktop application which uses SQL server DB. DB is suppose to be on local machine  or network, but there will be one copy on remote sql server which should have all the local updates as well.

So lets say on location1 i am working on application and making some changes in data...when i go to location 2 where this application is also installed with its local DB it should have the same data. Which i understand has to go through common medium. So one option is to have a common web DB copy on remote sql server and both these machines DB to be synced with the web copy.

Second option could be that all locations use directly remote SQL copy but that can have speed issues and that's why my client would prefer a local copy while using the application so he can work fast.

Any suggestion or inputs what would be the right way to meet this requirement.

Thanks,
MY
0
Comment
Question by:ziorinfo
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 200 total points
ID: 39669443
You can use SQL Replication to achieve that and keep your DB's in sync. See more at:

http://technet.microsoft.com/en-us/library/ms151198(v=sql.100).aspx
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now