Sql Server 2000 Replication Strategy help 
Author Message
 Sql Server 2000 Replication Strategy help

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

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Tue, 09 Dec 2003 06:29:23 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Sql server 2000 Replication strategy help

2. SQL Server 2000 Replication - Please Help

3. Help setting up a mirrored replication in SQl Server 2000

4. SQL Server 2000 Replication - Help Please

5. SQL Server 2000 Replication - Please Help

6. SQL Server 2000 Replication - HELP!!!

7. Replication between SQL Server 2000 and SQL Server 7.0

8. merge replication performance for SQL Server 2000 and MSDE 2000

9. Access 2000/Sql Server 7.0/2000 Replication

10. Access 2000 and SQL Server 2000 Replication

11. IMPORTANT Merge replication beetwen sql server 2000 and access 2000 + Msde

12. Researching SQL Server 2000 - Clustering Server and WAN Replication


 
Powered by phpBB® Forum Software