Guest_imported
New member
- Jan 1, 1970
- 0
I need help to setup the sql server 2000 replication environment.
The requirement is to have two sites. One site is the master and the in the second site it should be possible to update a particular column in 5 tables but should not be propagated to the master back.
ex.
Table A contains 5 columns
col1
col2
col3
col4
col5
While replicating the Table A to the second site only 4 column values should be passed and the col5 should be derived in the second site using triggers and the derived value should not be replicated back to the master.
Can you suggest which type of replication would be suitable or if possible can you specify any links which would help me.
Thanks in Advance
Regards
Sai
The requirement is to have two sites. One site is the master and the in the second site it should be possible to update a particular column in 5 tables but should not be propagated to the master back.
ex.
Table A contains 5 columns
col1
col2
col3
col4
col5
While replicating the Table A to the second site only 4 column values should be passed and the col5 should be derived in the second site using triggers and the derived value should not be replicated back to the master.
Can you suggest which type of replication would be suitable or if possible can you specify any links which would help me.
Thanks in Advance
Regards
Sai