How to perform mass update with merge replication?

  • Are you updating one row at a time? If so, I would suggest selecting the data into a "work" table that isn't replicated, perform the data manipulation in the work table, then update the live table with a single Update statement or in small batches with a pause between them.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply