transfering data between systems over the web

Question

0.00/5 (No votes)

See more:

I have a customer that I do SQL 2005 work for. They have a customer that also uses MS SQL. Right now we move data from their customer to my customer by email. Their customer sends emails (automated) with text file attachments and we have processes that read that text file into our database. It's been running smoothly for several years. Now we want to move things forward a bit. Their customer would like to be able to automatically transfer data directly to my customer's db via some sort of service across the web. There is no need for a UI. We have quite a bit to figure out yet but in essence their system will periodically check for new/changed data and then open a connection to my customer's system and call up a stored procedure to which it will pass the appropriate parameters. Is a vb.net web-service the best way to go with something like this or is there something else that would make more sense?

Posted 2-Mar-12 1:55am

avianrand

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2012-03-02T04:10:00

Solution 1

I would use a authenticating web service to do this. An encrypted session would also be nice. Just Google for "web server authentication and encryption" for some very good reads.

You really don't want some hack idiot messing with the data as it goes over the net, you don't want them using your web service unauthorized, and you surely do not ever expose an SQL server directly to the Internet.

Posted 2-Mar-12 4:10am

Dave Kreskowiak

Comments

avianrand 2-Mar-12 20:42pm

Yep. SSL, IP filtering, authentication, etc. All in the plans. Just wanted to be sure that a web service is the best way to go on this. Since there won't be a U.I. for this, we just wondered if there were other ways to go that might be better. Thanks for your answer.