Solved

SQL DB copy on web as central copy

Posted on 2013-11-21
1
159 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Designer 19 47
optimize stored procedure 6 29
SSRS Enable Remote Errors 4 27
IF THEN WITH A BEGIN END 4 10
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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

825 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