Tuesday, March 20, 2012

BOL Quote: "Two Merge Replication Proceses..."

Hi everyone,
I was hoping someone could offer some insight into a quote from the SQL
Server Compact 3.5 BOL
(ms-help://MS.SSC.v35/MS.SSC.v35.EN/sscmain/html/7434b4c1-5099-4d83-b5f9-75a9e6e72faa.htm):
"You cannot start two merge replication processes at the same time on the
same database."
I'm not sure what "same database" means. Is it referring to the same server
database? Let's say I have a sales force where SQL Compact 3.5 installed on
each agent's laptop. Does it mean only one sales agent at a time can merge
with the corporate server? Please tell me this is not true. We need to have
multiple agents replicating simultaneously.
Thanks very much.
Tom Baxter
Hello Tom,
I understand that you are confused by the descriptioin "You cannot start
two merge replication processes at the same time on the same database." in
BOL. You'd like to know only one sales agent at a time can merge with the
corporate server if you use merge replication.
I believe it's not true. You could have multiple agents replicate
simultaneously though there is only process running for the specific
database you'd like to replciate.
If you have any further concerns, please feel free to let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment