locked
ADO.NET Sync Framework v1 and SQL 2008 Merge Statement RRS feed

  • Question

  • I was curious if anybody has used the SQL 2008 Merge statement with the Sync Framework. It seems that it would be possible to get all of the incremental inserts and updates and then use the merge statement on the client/destination side instead of calling two different commands.

    Has anybody done this? If so is there any performance gain or loss by doing this?

    Wednesday, January 27, 2010 3:14 PM

Answers

  • 1. Did not see any performance gain by using Merge Statement.
    2. Since Merge is associated with SQL 2008, then this provider will be specific to SQL 2008.
    3. We have not implemented using Merge State in the sync command so we did not test it before.

    Thanks.


    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, January 29, 2010 1:52 AM
    Answerer
  • As Leo points out, we dont see how using the MERGE statement provides any perf benefit.
    However having said that, please let us know why you are thinking of using the MERGE statement in the first place. Typically MERGE is used when you want to determine a targe row to be an INSERT or an UPDATE depending on the contents of a source table. I do not understand why you maybe needing this to be used on the destination replica.
    This posting is provided AS IS with no warranties, and confers no rights
    Thursday, February 4, 2010 7:28 AM

All replies

  • 1. Did not see any performance gain by using Merge Statement.
    2. Since Merge is associated with SQL 2008, then this provider will be specific to SQL 2008.
    3. We have not implemented using Merge State in the sync command so we did not test it before.

    Thanks.


    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, January 29, 2010 1:52 AM
    Answerer
  • As Leo points out, we dont see how using the MERGE statement provides any perf benefit.
    However having said that, please let us know why you are thinking of using the MERGE statement in the first place. Typically MERGE is used when you want to determine a targe row to be an INSERT or an UPDATE depending on the contents of a source table. I do not understand why you maybe needing this to be used on the destination replica.
    This posting is provided AS IS with no warranties, and confers no rights
    Thursday, February 4, 2010 7:28 AM