Hi, This is Prashant here, I am trying to replicate a table with column filters using Transactional replication. I am facing huge problems in doing so. I would like some help regarding the same. Any suggestions would be welcome. Now the Problem. I am replicating say for example an employee table with columns Empid int and PK,EmpName varchar(50) & EmpRating decimal(18,2) from SERVER A to SERVER B. The first time I would like to replicate the entire table from SERVER A to SERVER B which works fine. But now here is the catch ... The EmpRating column in the Employee Table on SERVER B keeps on changing on a daily basis. Here I want to configure the the replication to replicate only the Empid & EmpName columns but not the EmpRating column. Is this possible? If yes then how? Where I am going wrong ? Any help in this matter would be highly appreciated. Thanx & Regards Prashant
Hi,Not so easy mate ...try it for yourself & you would see what I mean.If there are 3 cols on Table A in Server A I want all those cols on Table B in Server B. On top of that I would require only 2 cols to be replicated from Server A to Server B because my 3rd col is regurlarly updated on Server B but not on Server A. This 3rd col value is vital for our business.Do let me know if you didnt get me.Best RegardsPrashant
