Merge Data from Two Source

• Mohit Nayyar

  Ten Centuries

  Points: 1008

  More actions

  February 11, 2004 at 4:30 am

  #84023

  Hi

  Is it possible to merge data from source and destination columns in Merge Replication.

  Example:

  Source: Column Name: Column Value

  Publisher: myData: Publisher Data

  Subscriber: myData: Subscriber Data

  Now the myData column is of varchar(100) and I want to have myData column at each end to be "Publisher Data Subscriber Data".

  Please help if it is possible or is there any other way to implement this thing.

  Please provide some good links about Replication.

  Thanks

  Thanks
  Mohit Nayyar
  http://mohitnayyar.blogspot.com/
  "If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  February 11, 2004 at 4:44 pm

  #493725

  You can replicate data anywhere as long as the DataTypes are the same on both Publisher and Subscriber!

  ---

  Kindest Regards,

• Mohit Nayyar

  Ten Centuries

  Points: 1008

  More actions

  February 11, 2004 at 10:34 pm

  #493737

  Thats OK.

  But i would like to merge the content of publisher and subscriber at both ends. I haven't got any help on this topic.

   

   

  Thanks
  Mohit Nayyar
  http://mohitnayyar.blogspot.com/
  "If I am destined to fail, then I do have a purpose in my life, To fail my destiny"