× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi All

I have a remote Windows VPS that I have access to that I want to transfer
data from in order to update a local database. The data is currently in an
access database, but SQL Server Express could easily be substituted.

I have access to the server via Remote Desktop but the Server is not
actually part of my network and my local machine does not have a fixed
address (although it could).

The transfer process has to operate on a scheduled and unattended basis
(i.e. I don't want to log in to run something), I know I can do it with FTP
and some scripting on the client and server ends but I wondered if there was
a better way. If I can I'll script this stuff in perl but that's mostly a
preference.

Apart from FTP, what are the cheap, free and secure options to allow me to
pickup data from this server (yeah I know I'm asking a lot). I've considered
things like SSH, SFTP, SCP, and even database replication but was wondering
what options people had explored in the past that might save me some pain.
Maybe there's even some funky Windows things that will do it

I'm pretty much open to any suggestions as to what the options are as I'm
just as much curious about how it can be done as anything.

Regards
Evan Harris



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.