private static void SyncTable(SqlConnection targetConn, TableSchema tableSchema, SqlConnection sourceConn) { try { targetConn.CreateSyncTables(tableSchema); sourceConn.BulkCopyData(targetConn, tableSchema); targetConn.DeleteData(tableSchema); targetConn.MergeData(tableSchema); } finally { targetConn.DropSyncTables(tableSchema); } }