Retrieving data from BE's on multiple remote servers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Not sure whether this questions should go in this topic or design......

I am creating an application to distribute to employees at a number of
remote locations. There is a server at each of these locations so I was
planning to split up the app into FE and BE. On a weekly basis I would like
to "collect" the data from the BE's and consolidate on my local server.

I assume linking tables is out due to poor performance over a WAN.

Some other thoughts I had were -
1. Running a scheduled VBScript task to copy the files to my local server
2. Running a scheduled VBScript task to run a query to email the table
contents to me
Any suggestions ?
I haven't though a lot about the details yet, just want to make sure that I
have the concept right first.

TIA

IK
 
Back
Top