Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jawad Khan
Starting Member
21 Posts |
 Posted - 2008-08-12 : 08:43:51
|
| Hi all,Sorry for such a long question…. But I’ll appreciate your reply.I want to invite you to give me suggestions and ideas about the scenario.I have developed an application in VB.NET and SQL Server 2005 express edition. This application runs on single PC. This application is running at 3 remote places independently. The information sharing takes place using fax, mail etc. and re-entered at all locations. Of course this is not an optimal solution to the management.(I know the best solution is to use web based application with a single database residing on the server. But it is not possible, because the remote places are operational for the whole day and the internet connectivity is limited.)Now the management has decided to change the architecture. Each location will have its own database and data will be stored in it. The data from all three locations will be uploaded to the server residing at Head office at the end of the day and when the internet connectivity is available. The data will be downloaded from server at other locations.I don’t want the databases of all the 3 locations to be fully synchronized. The server will have the full set of data (i.e. the data uploaded from all three locations + the data entered directly in head office). The locations will have distinct database. The sale record of location A will be uploaded to server but not downloaded to location B and C. Only those records will be downloaded to these databases that are related to them (e.g. the goods transferred from location A to B. This record will be entered at location A and B will download this record from server).Please advise me what strategy should I use?Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-12 : 09:17:20
|
| Merge Replication seems feasible in your scenerio. |
 |
|
|
Jawad Khan
Starting Member
21 Posts |
Posted - 2008-08-13 : 02:45:56
|
| Thanks for your reply...I am going to study the replication topic...Can you provide with some guidelines? Or you think the MSDN library is enough to help me? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 23:42:48
|
| Start with books online. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 13:26:13
|
| Start with this one:http://www.databasejournal.com/features/mssql/article.php/1438231 |
|
|
|
Jawad Khan
Starting Member
21 Posts |
Posted - 2008-08-16 : 09:51:51
|
| Thanks sodeep and rmiao. I'll be posting more after studying the topic. |
|
|
|
|
|
|
SQL Databases Synchronization