Best Windows-based database for replication/synchronization

Are there Windows databases on the market that allow a database to be maintained simultaneously in two locations? IOW, both copies of the database are automatically and continually kept synchronized with each other to within a few seconds.

A customer has asked me to upgrade a system I did for them many years ago, based on Microsoft Access, in order to improve the response time when the loading is heavy. Presently, the web server and the database server are on two different machines and I think the communication between the two is the bottleneck when traffic is heavy.

I'm wondering if a synchronizing database would be an effective solution without having to rewrite a lot of ASP code.

Thanks
tbone Received on Mon Dec 12 2005 - 16:02:32 CST