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 |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2009-04-03 : 01:48:18
|
| Which method of replication is used and how in this case:Case:I have remote location where I create a local database and run the application but Central database at HO. Where is need the daily updating of remote database data in our central server at HO. There is dialup connection at remote location.thanksASM |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-04-03 : 02:23:18
|
| if data is changed in the same tables on both locations - then probably merge replicationThanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
asm
Posting Yak Master
140 Posts |
Posted - 2009-04-03 : 02:27:39
|
| Yes, Data is changed at both end. Can u brief how can i implement the same. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-03 : 10:12:09
|
| How many clients/Subscribers will perform DML operations? If many ,you have to use Merge Replication and Conflicts are handled effectively in it. Look at booksonline. |
|
|
|
|
|
|
which replication ?