December 10, 2008 at 12:16 pm
I am a newbie regarding replication and I would like to do a replication
between SQL Server 2005 Std (publisher - distributor) and SQL Server 2005
(subscribers).
The type of replication should be filtered. Meaning that I would only like
to distribute certain info. to each subscriber. For instance, lets say that
each subscriber is a store so I would like to send the info, that applies
only to that store. But I dont want to maintain a different publication for
each store. Finally I would like that the stores can update data in the
publisher as well.
Can this be achieved? Could you provide some guidelines to it?
Thanks
ldj
December 10, 2008 at 12:28 pm
Hi,
Yes this is possible. you should look at Merge Replication which will allow you to update at publisher side and also subscriber side and then resolves the changes made.
check this ou:
http://msdn.microsoft.com/en-us/library/ms172989.aspx
check this out:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply