2-way replication vs. 1 way replication

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

2-way replication vs. 1 way replication

Author

Topic

GustiX
Starting Member

28 Posts

Posted - 2007-11-24 : 12:19:21

Hi

I am pretty new to SQL Server so I ask you to be forgiving if any of this sounds stupid :)

I am trying to set up the following:

We have 1 server machine with SQL server 2005 and 12 client computer with SQL Server 2005 Express
On the server there is a database which I need to replicate to the clients. This is simple enough
but the problem is that the clients also add data to one of the tables (in the local db).
If I set up a transactional publication with update subscriptions the data that the clients add
will also flow back to the server from the clients. This is all good but I don't want the
data that the clients add to flow back to the other clients

e.g.
1) client 1 adds 100 rows to local db.
2) 100 rows are sent to master db
3) 100 rows are sent to clients 2,2,3,4,5,6,7,8,9,10,11,12

The table looks something like this so you see there is no possibility of conflict
(client #1 only adds rows with client_nr field = '1')

client_nr datafield
---------------------------
10 'datadatadatadata'
11 'more data data data'

So the big question is. Can I add a filter so that the data from this one table
flows only from the subscriber to the publisher but not the other way?
I realise this could be solved by creating a publication on the clients but since
they are running sql express that is not possible.

Help please!

Best regards
Agust

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-11-24 : 14:49:12

Can't you create 12 separate publications on the server, each one filtered by the clinet ID so that the clients are only subscribing to their own data?

GustiX
Starting Member

28 Posts

Posted - 2007-11-26 : 04:06:06

I guess I can but it's a bit annoying to maintain.
Is there no way to filter a single table to one
direction only?

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-11-26 : 20:40:28

Sure there's a way - create multiple publications :-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources