I'm developing an asp.net web application to import data from an old (desktop) system to a new (web) system. I want to make a tool to import the data from the clients to the new system, ie the web application have access to the local database of each client, each of which are on different networks and the database server each is local. And since I'm using a web application, I wanted to import the data from a web application, is it possible?
I'm using Sql Server and Asp.Net;
In order for you to be able to do this in your web application that is on a remote server, the local databases will have to be exposed to the internet and you will need to access them through the external IP with valid credentials for SQL access Server. And that implies a lot of infrastructure effort.
A better approach to solving your problem is to implement in the Desktop version of the application, which already access these local databases, a routine to export the data to the database of your web application. Or develop and deploy a tool for that purpose.
