Replication Causes Client Application to Hang

45 pts.
Tags:
SQL 2005
VB.NET
I've got 25 Sites that are running an application that connects to MS SQL 2005, All the sites have their own copy of a database and have one similar database that holds information gathered from the different sites, now what is happening is that if a client registers at one institution and then later visits another institution they are able to retrieve the record that was captured on the previous institution where the client registered, So the current situation is that I consolidate client details database on a central server and then replicate (Push) the changes to all the sites. The problem is that during the replication process the application on site hangs if they are searching for a particular client's record and this will happen until the replication completes. Is there a way of running replication without affecting the client app.

Software/Hardware used:
MS SQL 2005, VB.NET Application
ASKED: October 9, 2009  8:56 AM
UPDATED: October 9, 2009  1:36 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following