Run local application with remote MS SQL server

  • 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

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic723093-149-1.aspx

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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