I am managing a docuement manament system and would like to implement replication between two sites. Which replication method be best?

Thks

Let’s make an assumption that you have ample CPU horsepower and enough bandwidth, then the answer to your question will be base on the user’s needs and requirements.  If one site was mean to “read” only the documents and there’s no urgency to get real time data then you may want to consider snapshot replication, but if the read-only site requires real time data then a transactional type of replication may be better.  On the other hand, if both sites will modify and update their respective copies of the document then consider “merge” replication instead.

Get your users involved and know what the requirements are and compute the amount of data that will be moving back and forth the wire.  Knowing these variables will help you decide which type of replication is applicable to your needs or whether or not replication is even appropriate or required.

I hope this information is helpful.

The other consideration is the amount of data. Snapshot replication will replicate the entire table(s) each time it's run, and that can be impractical for large table. Transactional replication replicates just the changes and is more suitable for large tables because the entire table only gets copied once during initialization.

You can then specify how frequently you want either kind to run. Snapshot is usually less frequent, like once a day. Transactional can also be once a day, but can also be every few minutes or immediate to keep the replicated data current.