Francisco Tapia
my.lists at verizon.net
Thu Mar 27 23:04:05 CST 2003
This is true, and in MSDE 2 (or sql server desktop) IIRC it 'can' be a publisher. Now if you are working w/ MSDE 1, I don't think the system can be a publisher then.... and you are not allowed to use transactional replication in MSDE's that I remember... but you still have merge and snapshot replication available to you... one thing I never liked about Sql Server replication is that having 2 pc's on the same network side be side, a merge replication transaction took over 2 minutes to replicate between the machines :O, not only that ALL of MS's documentation tells you that the processes of "when" the data gets there is not timmed that is to say the data gets there when it gets there, if the server is busy doing many other tasks it could be well over the two minutes before you see ANY data come accross... With my tests it ranged anywhere between 2 minutes up to 14 minutes, this of course was in a classroom setting but still the jist is the same in real life I'm sure. A thing about merge replication technique is that you must set up conflict resolution that is, if machine A is the publisher and Machine B is the subscriber and both have changes then the effective change that is kept is that of the publisher, NOT the one that made the change last. -Francisco http://rcm.netfirms.com/ On Thursday, March 27, 2003 6:57 PM [GMT -8], John W. Colby <jcolby at ColbyConsulting.com> wrote: : On a related note... : : MDSE claims to support replication. I don't know enough about MDSE, : never mind replication, to understand the issues - but... : : If each workstation ran MSDE and the server runs MSDE, then you have : effectively created SQL Server for more than "5 simultaneous users". : Since each user is now hitting a SQL Server Be on their own machine, : with only replication data going to the main BE on the server, it : certainly sounds like you could get fairly decent performance for 10 : or 20 users. : : John W. Colby : Colby Consulting : www.ColbyConsulting.com : : ---------------------------------------------------- : Is email taking over your day? Manage your time with eMailBoss. : Try it free! http://www.eMailBoss.com : : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com