Merge replication question

a 4 server merge replication over a T1 connection about 100 users connecting each server ,... effective or poor desicion?

<br />that's really a question like how long is a piece of string... <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />depends on:<br />- what else is done over the T1<br />- how often is data changed in each area<br />- how often is it replicated to the other areas<br />- what is the likelyhood of conflicts<br />- when you say 100 users connecting, is that via a web app?<br />- what security is there on the web app (Windows Integrated, anonymous, etc.)<br />- are all four areas in the same NT domain/2k domain<br />etc.<br /><br />If the databases are fairly static and the likelyhood of conflicts is low and accessed via fat applications in separate domains, then yes it could be a good decision...<br /><br />If the application is actually a web application with anonymous access, then it might be better to host the application/database in one location, since the site over t1 should give good performance anyway<br /><br />Cheers<br />Twan

Thanx !

BTW
we do only have 1 domain on all 4 sites
and the only data passing through the T1 is the merge data!

Is it a web enabled application used on all four sites? Is the link reliable or does it come down from time to time? What are your uptime requirements in the four sites?

So you have another connection between the sites for domain replication, and the domain is split into multiple NT sites to control replication?

loads of ifs and buts sorry...

Cheers
Twan