Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: SQL Replication

  1. 03-08-2011, 07:18 AM #1
    allenjarosz is offline Junior Member
    Join Date
    Jun 2007
    Posts
    26

    Default SQL Replication

    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?
  2. 03-08-2011, 07:46 AM #2
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Never tried that but we have a SQL low balance solution with two servers meaning if one server shuts down the other kicks in straight away.

    Whilst it is a fairly costly soultion it does mean we avoid problems like the one you had which we used to encounter daily before.

    I guess the issue will be with order numbers jumping out of sequence with replication.
  3. 03-12-2011, 02:23 PM #3
    allenjarosz is offline Junior Member
    Join Date
    Jun 2007
    Posts
    26

    Default SQL Replication

    I'm still hoping for more information from the design team, but here is an update where I'm at:

    Version 8.0.1.2 still has the same search function problems with replication enabled. We stopped replicating and the problem disappeared.

    Version 9x does not exhibit the problem. all seems well so far.

    Hoping for more comments!