.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Merge Duration of synchronization

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

Hi All,

I'm currently facing a problem when a lot of updates/inserts occur, the duration of the synchronizations sometimes jump from 1 minute to around 45 minutes or more.  Sometimes upwards of 3 hours, although they do eventually complete.  Both publisher and subscribers have great bandwidth so I'm assuming the bottleneck isn't there.

Is there anything I can do to achieve better performance for when these big changes are made?

View Complete Post

More Related Resource Links

Merge replication with Web synchronization - want to move virtual directory


Configuration: W2003 server, SQL 2008 ent, SQLCE 3.5sp1 (version 3.5.8080.0)

Using merge setup wizard many moons ago I set the path for my virtual directory to a disk that is now having space problems. As you can guess, I took the default path for SQLCE under C:/Progam Files. Occasionally a subscriber has an issue and when they reinitiate a subscription for some reason a file that is twice as large as the database begins to grow under the Web sync folder. This file has an .OUT extension.

I'd like to move the virtual directory to another disk to alleviate the space problems. But with hundreds of active subscriptions I'm leery of doing this since the database size is over 1gb and we do not want to break the current subscriptions!

Can I simply move the virtual directory using a copy/paste of the files and redesignating the path in IIS?

My snapshot folder is fine and I don't need to move that. It's just this IIS virtual directory that is on the C: drive.

I know I cannot create a new Web Sync point using the Wizard since it will break the subsritptions I have out there already.

Web Synchronization for Merge Replication for different domain


I need to synchronize 2 database server, one is hosted within my client intranet environment, and the other outside my client network in an external data centre. My client intranet network is protected by 1 or more firewalls.

For security concern, I am thinking of using web synchronization for merge replication to synchronize the 2 database so that the firewall only need to open port 443 (as opposed to 1433) and the data are encrypted using HTTP over SSL.

My idea is to setup the internet server as the publisher/ distributor and the intranet server as the subscriber.

However, I have never done this before, and anyone can advice on the following

  • For web synchronization, other than port 443, do I need to open up other ports in the firewall?
  • The internet server is not connected to the company domain. Therefore, when the intranet database server connect to the IIS on the internet server, will there be any problem?
  • Can web synchronization for merge replication work for 2 servers on different domain?
  • I have tried to set up similar test environment but keep getting the error, "The Merge Agent could not connect to the URL 'https://<server name>/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reach

Merge Replication synchronization direction


We have configured merge replication with synchronization property 'bidirectional'.


I have changed the synchronization property to Download-only to Subscriber, prohibit Subscriber changes and i applied the snapshot again, but the property has not been changed to prohibit Subscriber changes.

Still it is showing Bidirectional

Please let me know how to change this property.




venkat reddy

Mail Merge




I am after creating a mail merge documents from datasource and .dot template file on server side. Can you give me an idea how i will achive this?


Thanks in advance.



Syed Hussain



Merge SQL to Excel--Need .Net button to open on fly and have current SQL data!


           Hello all,
I do not know if this is the proper place to ask this, but my question is...
I have a SQL DB and I want to convert it to Excel Sheet (I did this using the wizard)!
In my aspx page I have a button.  So when I press this button I want the Excel sheet to open!  But I need the Excel sheet to show me the up to date information that is in the SQL DB.  

In Sync: Creating Synchronization Providers with the Sync Framework


The Sync Framework can be used to build apps that synchronize data from any data store using any protocol over a network. We'll show you how it works and get you started building a custom sync provider.

Joydip Kanjilal

MSDN Magazine August 2010

Synchronization Coverage: Code Coverage for Concurrency


As more and more multi-threaded software applications get developed, software development professionals need to adopt new tools, techniques and metrics that can deal with multi-threaded software. Synchronization coverage is a simple, practical way to do this and this article covers a prototype synchronization coverage tool for .NET, called Sync Cover.

Chris Dern, Roy Tan

MSDN Magazine September 2009

Foundations: Synchronization Contexts in WCF


After a description of what synchronization contexts are and how WCF uses them, the author demonstrates various options for extending WCF to use custom synchronization contexts, both programmatically and declaratively.

Juval Lowy

MSDN Magazine November 2007

CONCURRENCY: Synchronization Primitives New To Windows Vista


Windows Vista has lots of goodies for native C++ developers including condition variables, slim reader/writer locks, and one-time initialization.

Robert Saccone and Alexander Taskov

MSDN Magazine June 2007

Concurrent Affairs: Build a Richer Thread Synchronization Lock


In my last column, I showed the various thread synchronization mechanisms employed by the Microsoft® . NET Framework (see Concurrent Affairs: Performance-Conscious Thread Synchronization). I then examined the performance characteristics of all these mechanisms and determined that the Interlocked methods performed the best because the calling thread never has to transition to kernel mode.

Jeffrey Richter

MSDN Magazine March 2006

Concurrent Affairs: Performance-Conscious Thread Synchronization


In my career, I have architected and implemented many thread synchronization techniques. This has provided me with a lot of experience that has shaped the way I now think about thread synchronization problems.

Jeffrey Richter

MSDN Magazine October 2005

Basic Instincts: Thread Synchronization


My last three Basic Instincts columns have examined techniques for using asynchronous delegates and creating secondary threads. Those columns demonstrated how to introduce multithreaded behavior into your applications.

Ted Pattison

MSDN Magazine September 2004

.NET Column: Safe Thread Synchronization


By far, the most common use of thread synchronization is to ensure mutually exclusive access to a shared resource by multiple threads. In the Win32® API, the CRITICAL_SECTION structure and associated functions offers the fastest and most efficient way to synchronize threads for mutually exclusive access when the threads are all running in a single process.

Jeffrey Richter

MSDN Magazine January 2003

Web Farms: Use Data Caching Techniques to Boost Performance and Ensure Synchronization


Performance is an important concern for any application, but becomes critical when the app is a Web Service accessed by thousands of clients simultaneously. One hardware approach to distributing Web Services requests evenly is a Web farm consisting of multiple servers. Once on a Web farm, Web Service performance can be improved by using ADO.NET DataSet objects to cache frequently accessed data, reducing round-trips to the database. Here the author describes data caching in a Web farm environment and discusses how to avoid the cross-server synchronization problems inherent in this approach.

David Burgett

MSDN Magazine December 2002

How to merge 3 separated color (Red, Green and Blue) saved as grayscale images images into colored i


Hi friends, I have separated Red, Green and Blue color from a bitmap image and stored it in grayscale (obviously).  Now I want to know how can I merge it so that I can get the exact previous colour, when I am merging them by reading its color values but it is giving  me grayscale image :( . Please help me out with some working sample code. Thanking in anticipation.

I am using the following code:

 public bool mergeToRGBandWriteBitmap(string sourceRFile, string sourceGFile, string sourceBFile, string targetFile)
            bool isSuccessfullywritten = false;
                Bitmap bitmapRed = (Bitmap)Image.FromFile(sourceRFile);
                Bitmap bitmapGreen = (Bitmap)Image.FromFile(sourceGFile);
                Bitmap bitmapBlue = (Bitmap)Image.FromFile(sourceBFile);
   Bitmap afterMerge = mergeRGB(bitmapRed, bitmapGreen

merge word document



I recently created a team site on the SharePoint for projects management and our team will use the word document for inserting the information about the project that they work on it,

My case is:

for each project have multiple documents and i created a user control by VS.2005, this user control contain a drop down list contain all projects and merge button, when the user choose any project and click merge i will use the Work dll to merge all document that related to the project and export to the user.

This is my code

private void mergeDocument()


ApplicationClass WordApp =

How to merge separate control flows?

Howdy, This seems a simple question but I can't find a clear answer anywhere... I have an SSIS package that processes flat data files, one-by-one, in a loop, until there are no more files. Before proceeding, I have to make sure the specified file exists. So I create a Script Task that checks for the file. File Exists = Task "Success" else Task "Fail". I then branch from that task to either proceed with the Data Flow task, OR else to log a failure message. IN EITHER CASE, I need to eventually return to the same cleanup Task in order to prepare for the next file. However, if the failure pathway flows into the Cleanup task, then the Success pathway always terminates just before, and does not execute the Cleanup Task. How can I ensure that two mutually exclusive pathways can return to the same Task? Thanks much!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend