Merge replication with filters -- sql server replication

sql server replication : Merge replication with filters

Paul Ibison
5/17/2006 4:44:52 PM

Ricardo,
you could look at dynamic filtering - based on the -HOSTNAME paramater or
HOST_NAME() or SUSER_SNAME() values. You'll either need these values in your
tables or you can have a mapping table or you could use UDFs. These filters
are not intended to be dynamically changed however. Also, I'd mention that
you might be better using static filters rather than the dynamic ones - the
performance is significantly better. In this case you'd need a separate
publication per subscriber which might not be viable.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Ricardo Alvarez
5/17/2006 4:58:54 PM

Hi, first, excuse my poor English.

I am new in the world of SQL Server and have a doubt of applying filters to
data to synchronize.
I have an application in a PDA, and the database in SQL Server 2005, and I
want to filter the rows by several criteria, for example, orders introduced
by certain person, which are of certain date, made by certain client..., and
to be able to put a mixture of these conditions, indifferently. The filters
would be different for each subscription, each subscriber even can make
different filters in every synchronization.
How can I use them?

Thanks

Andrew Grillage
5/18/2006 8:57:59 PM

We have a replication alternative that allows you to synchronize your SQL
Server with remote PDAs and you can define complex sharing criteria very
easily via a GUI environment. Let me know if you are interested.

Andrew

[quoted text, click to view]

Ricardo Alvarez
5/19/2006 12:00:00 AM

I'm interesed, can you give me more information?

Ricardo

"Andrew Grillage" <agrillage@yahoo.com> escribió en el mensaje
news:ejPCH0qeGHA.3808@TK2MSFTNGP02.phx.gbl...
[quoted text, click to view]

Hilary Cotter
5/19/2006 10:29:46 PM

I suggest you email him directly.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

ciroE
5/23/2006 9:07:55 AM

Paul,

I am working right now with a similar situation, and already applied
the <field_name>=HOST_NAME() techniques as explained in the SQL Server
2005 Help file ( dynamic filtering for Pull-type subscribers ).
Now the complication is that I need to manage different schemas between
the publisher and the subscriber ( with a common set of columns, of
course ). Up to now, even without asking any snapshot initialization, I
always get an error from the replication agent, saying that the schemas
on publisher and subscriber are different. Any tip ?

Thanks.
Ciro Ettorre
Bologna - Italy

Paul Ibison
5/30/2006 8:22:12 PM

I generally manage different schemas by using views. The base tables remain
the same, or perhaps a subset, but with no radical changes. Where necessary
I use partitioning of tables. I find views and InsteadOf triggers present a
simple solution from the point of view of replication maintenance.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul Ibison
6/5/2006 12:00:00 AM

Please can you contact me offline at Paul.Ibison@ReplicationAnswers.Com?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

ciroE
6/5/2006 4:44:25 AM

Hi Paul,

thanks for the answer. The trick of the Views could really be
interesting.
Anyway, I have also another question for you:

could you be available for a consultancy ( on the SQL Server 2005
platform ) for our company about such arguments ?
The case is very common: a subscriber that want to share a sub-set of
data with another subscriber ( dynamic filtered using the HOST_NAME()
based pull subscription ), with data already existing on each side (
nosync type initialization ).

Regards,
Ciro

Paul Ibison ha scritto:

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

View Other Months
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
October 2008

home · blog · groups

Questions? Comments? Contact the dn