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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!