At times our local office, which takes telephone orders looses its connection to the Internet effectively shutting down our business.
Web orders are still being processed however by customers outside the company which have a good connection to the Internet.
Seems that SQL replication is the answer to our problem. While our connection to the outside world is lost, we may still enter orders on our local copy of storefront, then once the connection is restored SQL Server can work out the database changes, unifying the connection to the www SQL Server.
Has anyone tried this technique, and how did you get it to work?
We have tried, and all seemed to work fine until this morning, when we were not able to search the customer database seems to be a problem with SQL tries to create a temporary table but the aspdotnetstorefront database wont allow a modification so the search times out fairly quick.
Any help?