December 19, 2005 at 3:04 pm
I am trying to set up replication bewteen two SQL 2K servers across a WAN (256k). I have created a publication with two tables, one the parent table, the other the child table, using Transactional Replication and Queued Updating. These are Audit tables so there will be no updates at the subscriber, just new record inserts, so I set them up using the Automated Identity Range Management feature.
The problem is that I want to filter the publication so that only selected rows of the parent (and it's related children) get passed on to the subscriber. Setting up the parent table was easy enough using the Filter Rows tab of the Publication Properties dialog box was easy enough, but I do not see how to set up the filter for the child refering to the parent record.
I think I want to do a join filter but that only seems to be discussed in reference to Merge replication. Is their any way to do what I want with the Transactional Replication / Queued Updating model I chose?
Mark
Mark
December 20, 2005 at 1:29 pm
Views can be replicated so why not create a view witht the parent/child rows in it.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 20, 2005 at 2:24 pm
I have never worked with replicating views. If I use a view, will the data end up in the underlying tables on the subscriber? Or just a materialized view there?
Mark
December 20, 2005 at 2:41 pm
I really don't know. I've not replicated views, I just know that they can be replicated. I would venture a guess at the data winding up in the base tables but the best way to be sure is to test it.
Sorry I can't be of more help
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply