Bulk update of tables and tracking tables during synchronization RRS feed

  • Question

  • Using SQL Server Profiler, when or downloading uploading, we observe that the sync framework finds each record in the source database, updates the corresponding record in the target database and then updates the tracking information for the same record in the tracking tables in the target database.  This is 3 queries for each record.  As a result, it takes 10 hours the first time we sync more or less identical databases with 1.25 records in 18 tables.  Is there a way to use bulk procedures to perform the read, write and update procedures?

    Howard P. Weiss

    Wednesday, June 3, 2015 1:37 AM

All replies