通过Web在系统之间传输数据 [英] transfering data between systems over the web

问题描述

我有一个从事SQL 2005工作的客户.他们有一个也使用MS SQL的客户.现在，我们通过电子邮件将数据从他们的客户转移到我的客户.他们的客户发送带有文本文件附件的电子邮件(自动)，并且我们具有将文本文件读入数据库的流程.它运行已经好几年了.现在，我们希望将事情向前推进.他们的客户希望能够通过网络上的某种服务将数据直接自动传输到我的客户的数据库中.不需要UI.我们还有很多要弄清楚的地方，但是从本质上讲，他们的系统将定期检查新数据/更改过的数据，然后打开与我的客户系统的连接，并调用一个存储过程，它将适当的参数传递给该存储过程. vb.net Web服务是处理此类问题的最佳方法，还是还有其他更有意义的方法?

解决方案

我会使用身份验证网络服务来做到这一点.加密的会话也很好.只是Google提供了网络服务器身份验证和加密"功能，因此获得了很好的阅读效果.

您确实不希望某些黑客愚蠢的人在数据流经网络时弄乱它们，您不希望它们未经授权就使用您的Web服务，并且您绝对不会将SQL Server直接暴露给Internet. /blockquote>

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?

解决方案

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.

这篇关于通过Web在系统之间传输数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！