One backend across multiple sites

  • Thread starter Thread starter Falty
  • Start date Start date
F

Falty

I have designed a whereabouts system which works fine for head office, the
issue has been raised that the directors travel among various sites and need
to recieve the same up to date information.

We have servers at each remote site and they are updated via DFS. To have
the sites link directly back to head office renders the system unhealthily
slow. I was hoping to use the DFS to have a local copy of the backend which
is replicated everytime a change is made but when users are on the system it
holds the backend open and stops the replication. The database is only
updated from one user at head office. Is there a way of sharing the real time
data across remote sites or is this project dead in the water.
 
If your backend database is SQL Server then it can be done. You'd have to
allow remote access to your database one way or another though - either
through the Internet or via a VPN connection. If you don't own SQL Server
you can use MSDE, which is a free version of SQL Server.

Sorry I can't provide more specifics though - you'll probably have to do
some additional research.

Steve
 
Back
Top