可能COM preSS SQL Server网络流量？ [英] Possible to compress SQL Server network traffic?

问题描述

我有一个需要连接到远程SQL Server通过WAN .NET客户端，是有可能在客户端和服务器之间的COM preSS SQL流量？

I have a .NET client that needs to connect to a remote SQL Server over the WAN, is it possible to compress SQL traffic between the client and the server?

我使用.NET 3.5和SQL Server 2005及更高版本。

I am using .NET 3.5 and SQL Server 2005 and greater.

推荐答案

纵观 connectionstrings.com 这里为SQL Server 2008，数据库供应商不具备某种COM pression方案......您可能需要编写一个包装的不同端口上，该COM presses数据，通过使用前端，发送数据通过该端口，从那里，COM preSS它，它横跨发送到远程端点，DECOM preSS它，并将它转发到真正的TCP / IP端口的服务器是坐在。

Looking at the connectionstrings.com here for SQL Server 2008, the database providers do not have some kind of compression scheme...You may need to write a wrapper on a different port, that compresses the data, by using the front end, send the data across that port, from there, compress it, send it across to the remote endpoint, decompress it, and forward it on to the real tcp/ip port where the server is sitting on.

通常的SQL Server坐落在端口1433 ...

Usually SQL Server sits on port 1433...

由于一张图片胜过千言万语......

Since a picture is worth a thousand words....

+--------+                                             +--------+
| CLIENT |                                             | SERVER |
+--------+                                             +--------+
  Port 1234                                          Port 1433 <+--+
     |                                                             |
     |                                                             |
     +={Module}=    <=>    TX/RX    <=>   ={Module}=  -+-----------+

该模块将坐在那里，在攻防两端融为一体pressing / DECOM pressing ...

The module will sit there on both ends compressing/decompressing...

老实说，听起来会有参与其中的防火墙的漏洞工作将必须被刺破，使COM $ P $进出pssed资料...扔在NAT / SNAT可能使事情复杂化。 ..

To be quite honest, it sounds like there will be work involved as the Firewall's holes would have to be punctured to allow the compressed data in and out...throw in NAT/SNAT could make things complicated...

有一个在这篇文章中，我写了 $ C $的CProject ，即code作为一个流量重定向，并可以很容易地修改为使用COM pression / DECOM pression方案。

Have a look at this article that I wrote on Codeproject, that code acts as a traffic redirector and could easily be modified to use the compression/decompression scheme..

这篇关于可能COM preSS SQL Server网络流量？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！