Can replication horizontal filter use join table?

[theresatan]

Hi,

I have a request that setting up a replication and the row filter need to join couples of other tables.

Is that possible? If yes, what is the syntax? It seems there special syntax for the replication filter.

Thanks!

Theresa

 

[Catadmin]

In the replication row filter, you essentially do your join as normal. Yes, there's a certain syntax that Replication forces you to use, but all you do is add on to that.

It's been a while since I worked with replication, but I believe I just added JOINS and WHERE clauses to the syntax that existed previously when creating my publications.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[theresatan]

Catadmin:

Thank you for your quick response.
You are right, it is doable and my problem was solved.

Thanks again!

Theresa

 

[Catadmin]

NP. Glad I could help.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"