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 network, 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.