Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
impact.kumar
Starting Member
1 Post |
 Posted - 2009-05-21 : 10:20:41
|
| Dear Readers, 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 support document relevant to the above subject.RegardsJayakumar |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-06-13 : 07:06:41
|
quote:
Originally posted by impact.kumar
Dear Readers, 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 support document relevant to the above subject.RegardsJayakumar
As you are using MS SQL Express Edition you can not use any of the high availability features provided by microsoft...refer to this [url]http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx[/url] You should upgrade too any other edition...Regards,Ahmad Osama |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-06-14 : 11:50:14
|
| You must be using Merge Replication with Enterprise or Standard Edition for SQL Server. |
|
|
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-16 : 08:57:44
|
| Merge Replication would be a perfect fit, you need to carefully design the database before implementing the replication, If you are performing the room booking how would you handle over booking.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
|
|
|
|
|
|
Run local application with remote MS SQL server