Hpw to update a table in a remote database

Eduardo Arias

Hello there!

I don't know if this is the right place to post this question. If not, I apologize.

I'm developing a web application that at some point of its processes has to update a table in a remote database. Now, this remote database is located in my client's office and my web application is located in a managed web hosting account. Anyway, I was thinking on creating a text file in my web application and send it, through SSL, to an application I would create located in my client's web site, and this application will take care of updating the table Indifferent ... but I'm sure that I there are different ways of doing this .. to be more specific ... I think that there is an easy way ... right? ... Confused

If someone could point me to a book, article, code or tutorial, I would greatly appreciate it.

Eduardo

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bechir Bejaoui18y ago
Yes both can achive the same goal, but there is an issue that I think is very important here, In fact , If you use sockets object in remote context dont forget to engrypt your data before send it because in my point of view every one how has an idea about how to deal in remoting context can intersept your data.
In case of web service there your can modify the credentials or add a header to the web service core who has userid and password so that, It can't be used by every one
Bechir Bejaoui18y ago
Yes both can achive the same goal, but there is an issue that I think is very important here, In fact , If you use sockets object in remote context dont forget to engrypt your data before send it because in my point of view every one how has an idea about how to deal in remoting context can intersept your data.
In case of web service there your can modify the credentials or add a header to the web service core who has userid and password so that, It can't be used by every one
Eduardo Arias18y ago
Hey,

well. the table will be update it on-demand ... this means that the user will decide when to update the data to the table from a remote table. I was thinking in using xml web services, but I just learned that I can have what is called .Net remoting to achieve this. What do you think?
Bechir Bejaoui18y ago
I ask you, are the update processes automatically "preiodically/not" done , relating to a given event or manually
If , I know this detail I think that I can propose you a realizable solution