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.
| Author |
Topic |
|
hassanz25
Starting Member
6 Posts |
 Posted - 2009-02-16 : 01:31:20
|
| I want to do replication between server and different clients running SQL. I want all of them to bidirectional and partial replicated. In partial i have to select few row from one table and besd on the ID of this reocord I have to bring infromation from several other tables to be partially replicated. Is it possible? Thansk in advanceHassan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-16 : 08:54:50
|
quote:
Originally posted by hassanz25
I want to do replication between server and different clients running SQL. I want all of them to bidirectional and partial replicated. In partial i have to select few row from one table and besd on the ID of this reocord I have to bring infromation from several other tables to be partially replicated. Is it possible? Thansk in advanceHassan
Then you need Merge Replication with Filters Applied. |
 |
|
|
hassanz25
Starting Member
6 Posts |
Posted - 2009-02-17 : 01:05:44
|
| Hi all,Can you please tell me about filtering in detail... for example i have two tables Table1 and Table 2 I want to get one record from Table1 (is it possible, subscriber can send a value so that we can get a desirable record from Table 1) and all the records relating to the reocrd(we got from table 1) from Table 2.. and replicate it all.. on both ends...thansk again in advance....Hassan |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-17 : 08:40:36
|
quote:
Originally posted by hassanz25
Hi all,Can you please tell me about filtering in detail... for example i have two tables Table1 and Table 2 I want to get one record from Table1 (is it possible, subscriber can send a value so that we can get a desirable record from Table 1) and all the records relating to the reocrd(we got from table 1) from Table 2.. and replicate it all.. on both ends...Please elaborate on this.thansk again in advance....Hassan
|
|
|
|
hassanz25
Starting Member
6 Posts |
Posted - 2009-02-17 : 18:06:34
|
| Hi,thanks for response...For example there are two tables...Tabel1 and table2 table1 has a foriegn key of table 2. so the subscriber wants to get a specific reocrd from table1 and all the related records from table2..(records in table2 have the relationship with the record in table 1)Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-17 : 23:08:09
|
| Have you tried in the filter? |
|
|
|
hassanz25
Starting Member
6 Posts |
Posted - 2009-02-18 : 18:15:06
|
| How can publish come to know which record from Table 1 subcriber wants...Should not subscriber send some kind of value which can be used in 'Where' Clause |
|
|
|
|
|
|
Replication SQL 2005 - Filtering