Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Filtered replication

 
   Database Forums (Home) -> Replication RSS
Next:  why a grouping error?  
Author Message
ldj_pr

External


Since: Dec 09, 2008
Posts: 1



(Msg. 1) Posted: Tue Dec 09, 2008 12:55 pm
Post subject: Filtered replication
Archived from groups: microsoft>public>sqlserver>replication (more info?)

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

 >> Stay informed about: Filtered replication 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Replication-Replication Distribution Subsystem: agent (nul.. - After migrate SQL 2000 replication to SQL 2005, by script and have maked some changes, like drop some publications and have added many articles in one, this message has appered so often: Replication-Replication Distribution Subsystem: agent (null)..

Perform only schema change replication and avoid data repl.. - Hello! I am having typical scenario in sql merge replication. I need to synchronize table with data and schema changes. But for one column in the table should not be replicated. Schema of the column should be replicated but data should not be. The column...

accumulating the result of a snapshot replication filtered.. - hi all, Im running a snapshot replication on table. first, i gonna copy the entire table with a regional filter other than date second i'm going to replicate a days worth of data by using both the regional filter and date filter (getdate) to..

Help with replication error - I am getting this error: The row was not found at the Subscriber when applying the replicated command. I have a transactional replication with row filters with UDFs on some tables and we are replicating data from internal sql server db to web sql..

Replication From 2005 to 7.0 - Hi, I am looking to set up transactional or snapshot replication from 2005 to 7.0, but I am struggling as this does not seem to be well documented, and Enterprise Manager doesn't seem to be able to see 2005. I have a publication set up in 2005 - what d...
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]