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 |
|
Bobba Buoy
Starting Member
36 Posts |
 Posted - 2004-12-30 : 15:27:35
|
| I have a network that has sql server 2000 on the "main" machine which drives a web application. We occassionally take a laptop off of the networ, to receive and process data at remote sites. Here are my questions:1) Is Merge Replication my best approach here? While we are off-line with the laptop the "main" machine will be receiving data. When we go back online with the remote machine we will need its data "merged" back into the "main" db.2) Is there anything I should know about the merge replication process? I tried it 6 months ago and couldn't get it to work. I was having a hard time getting the initial snapshot to work. 3) My db has PK/FK cascading relationships. Is there anything I have to know about setting that up and then using merge replication? I know when I set a primary key I have a "Not for Replication" choice and I am not sure what the significance of that is.Thanks! |
|
|
nbpatil
Starting Member
14 Posts |
Posted - 2005-01-03 : 17:27:51
|
| Hi..1)Yes,Here Merger replication will be the best in such situation where periodically you need to merge the SQL Data. Important :Setup Merge Replication when your "main" machine is in local network.It will let you complete the initial snapshot for Merge Repl.As remote network cannot be reliable as that of Local specially when you are doing process like 'initial snapshot'.2)Books Online : Go thru' it! Helpful. This sounds interesting : http://www.mssqlcity.com/Tips/replication_optimization.htm3)You must read some articles on "Primary Key/Unique Index" .Also u could find some info on the subject in SQLTEAM.COM forums.~ Nitin~ Nitin Patil (System Analyst) OSI Systems,Inc. CA,USA |
 |
|
|
|
|
|
Replication Question(s)