I have a server which is hosted in my office. I cannot offer remote access past our firewall because of the security risk. I have been told that an exe file or similair application can be written to automate the extraction of specified data from an sql dbase table and have that data exported and populate into another sql dbase on a web server with the same structure.
I have a connection string which I understand is all that is required in order design such an application. I guess I will then have to install this on my server.