How to Replicate the data without affecting application

• nanaeithi

  SSC Rookie

  Points: 27

  More actions

  July 27, 2009 at 5:29 am

  #207370

  Hi Geneious.......

  I am beginner,

  I have done Merge replication between my local database and remote database.It automatically created the one more coloumn 'rowguid' in all tables.It affects insert query in my application.How can i replicate the data without affecting my application.Please help me.

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  July 27, 2009 at 5:44 am

  #1030436

  Merge replication needs to be able to uniquely identify all rows in the database this is why a GUID is added.

  The GUID column that is created has a default value of NEWID() so it should not affect the application, what specific issues are you having?

  The other alternative with merge replication is to add your own GUID and handle it as part of your application

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  July 29, 2009 at 5:30 am

  #1031553

  Are your INSERT procedures/queries explicitly listing the column headings ?

  How is the insert failing ?

  What is your error ?

  Thanks

  Graeme