Tranactional Replicational across different schemas possible?

• si downes

  Grasshopper

  Points: 22

  More actions

  March 22, 2005 at 9:40 am

  #87825

  I'm attempting to use transactional replication to get data across from a database to my data warehouse for processing. Is it possible to have additional fields in the subscriber replication table as well as the fields specified in the replication process?

  At present I'm getting the error message:

  "String data, right truncation" and "Unexpected EOF encountered in BCP data-file" when I try to apply the snapshot to the destination table. Is this due to the additional fields present.

  I know I could avoid this by having the additional (empty) fields in the publisher table, but it would be nicer not to.

  Any advice would be great

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 23, 2005 at 8:19 am

  #548504

  I believe you can.

  But steps are very strict.

  1. Let the Snapshot create the table.

  2. Modify the Table structure at subscriber using a post script

  3. Modify the procedures ins,del,upd  for the subscriber (and probably included those in the same post script after the additional columns)

  hth

   

  
  * Noel