Post reply

Run local application with remote MS SQL server over internet

  • May 26, 2009 at 2:47 am

    #204493

    Dear Developers,

    We have Client/Server (VB.NET/MS SQL Express)based hotel management software,which works fine with in the LAN.But,we have problem in providing the solution to chain of hotels who uses the same software at different locations.Our client prefers Centralized DB server for all their locations and run the application over internet.

    They need a provision for running the application with local DB (offline)in case if connection to the central DB fails.And also the local DB should do the incremental data update in the centralized DB server once the connection is resumed.

    Kindly provide the solution for above problem.Please provide supporting document if any relevant to the above subject.

    Regards

    Jayakumar

  • May 26, 2009 at 2:56 am

    #999761

    Have you considered merge replication? Since there's a central 'master' server, that's probably one of the better ways.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 26, 2009 at 7:23 am

    #999877

    Thank you for ur lightning response.At client side we are using SQL express,Central DB shall be SQL server 2005.Is it possible to achieve the solution described above through web services?The bandwidth to each location shall be 256Kbps.

    The centralized DB shall be able to provide the service to 72 locations across the country with 300 + concurrent users.

    Thank you

  • May 27, 2009 at 10:27 am

    #1000804

    we faced a similar situation some time ago although not even close to that amount of users and sites. we had to have a central server and 5 remote locations with an average of 40 users total.

    eventually we used a VPN without local servers to cut down the cost and hoped for the best from our ISP.

    the fact is that for the last 3 years, downtime has been minimum and we are pretty happy with this configuration.

    the main problem has been the upload speed from the central site was also 256 kbs and that had to be upgraded to 512.

    even now though when requesting a large amount of data , the remote sites are slow but overall it was very cost effective.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply