SQL Server Performance

Filtering Columns ...Help

Discussion in 'SQL Server 2005 Replication' started by pdevadiga, May 2, 2009.

  1. pdevadiga New Member

    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
  2. dineshasanka Moderator

    Go to publication
    select Articles and select the table and unselect unwanted columns
  3. pdevadiga New Member

    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

Share This Page