473,778 Members | 1,901 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Configuring Peer-to_Peer Merge Replication

We have a situation almost exactly like that in the MS documentation
vis a vis peer-to-peer replication. We have three servers and three
user groups, one each in Chicago, New York, and Bermuda. Because of our
business practices, we are fairly confident that only one group will be
updating a given record at any one time but the users will be updating
their own local database servers and those updates must appear on all
three servers. Reading through the documentation, MS seems to recommend
peer-to-peer merge replication. Unfortunately, the documenation then
goes off and gives an example only of transaction replication without
updating subscriptions. Well, OK I sez, I'll just adpat what the docs
say but select merge replication. Doesn't work that way. Using SQL
studio, I have never been able to get to a peer-to-peer topology option
using anything but transaction replicas without updating subscriptions.
Using T-SQL, it looks like I can brute force peer to peer replication
with updating subscriptions but the sp_addmergedpub lication function
does not have any options for peer-to-peer topology.
So, what gives? How do I set up peer-to-peer merge replication? Any
help would be greatly appreciated!
Thanks.
Randy

Apr 10 '06 #1
1 2028
There did you read about Peer-to_Peer Merge Replication ?
I checked both BOL and the courseware and it only talks about
peer-to-peer transactional.
Markus

Apr 11 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1835
by: Daniel Danilin | last post by:
Hi, is there any plans to make WindowsXP Peer-to-peer SDK for .NET Framework?
2
1456
by: Marius Horak | last post by:
Ages ago (1980s) Datapoint (Databus) had basic peer to peer capability. Do we have anything in DotNet? MH
3
1470
by: Lyle Fairfield | last post by:
Do file-sharing (Kazaa) and/or instant-messaging (Skype) applications which rely on peer to peer networks threaten the security of MS-SQL data when they are running on a machine with a connection to the Server, as with, for example, an Access ADP? I do not use such applications, but a client wants an opinion. My opinion, which is - don't touch a peer to peer network with a ten foot pole -, is purely personal opinion and has no basis in...
2
1617
by: William Wisnieski | last post by:
Hello Everyone I've been asked to develop an Access database solution for a small business that currently has three Windows (XP) desktops and one Aapple Emac (OSX) on a peer to peer network. Will the Emac be able use the Access database database? Thanks, William
2
2139
by: Daniel Danilin | last post by:
Hi, is there any plans to make "WindowsXP Peer-To-Peer SDK" for .NET Framework?
0
1521
by: David Pendrey | last post by:
Greetings everyone, I am currently making a program which will need a peer to peer service but I have no idea how to make it work with the modern networks. Getting a peer to peer network on a single physical network seems easy enough, just send messages to IP addresses. I have a central computer which uses web pages to register who is on the network and who is not which I can make up easily. The problem arrises when trying to make it...
2
1472
by: Michael Bauer | last post by:
Hello, is there a simple way to detect whether the host machine of my c# application is connected to a windows network or whether it is connected peer-to-peer simply to one other machine (IP-adress unknown)? My first try would be to find typical UDP broadcasts within a certain period of time. If there are no such broadcast packages then I could assume that it is a peer-to-peer connection otherwise it is a windows network.
1
1698
by: Lisa000 | last post by:
I’m doing a project. and want to know how to implement peer-to-peer mode in this project. Suppose there is a multihop wireless network (multihop means some wireless devices cannot reach some other devices directly, they have to use relay devices to reach each other). Some of devices have data while others do not have. When any device has not data but want to get it, it will ask for data from anyone else who has the data and the latter will...
0
1740
by: Dom Rout | last post by:
Hello. Well, this is my first post on any USENET group anywhere, so I hope I get it right. Basically, I just want to get some opinions on a plan of mine for a new project. I want to produce a small, peer to peer, file sharing network for the use of myself and some of my friends. The purpose of this is basically to allow us to share files conveniently without relying on technology such as Windows Live Messenger (Yuck).
1
2618
by: rada.lambretha | last post by:
Configuring Linux as a Firewall * Making installation choices * Introducing iptables * Using iptables commands * Simplifying things with firewall GUIs * Adding proxy functionality As Linux gains increasing acceptance in corporate datacenters and
0
9632
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10302
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10136
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10071
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9925
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7478
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5501
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4036
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3631
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.