Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sql server 2000 replication strategy

Status
Not open for further replies.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top