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

问题描述

我有一个.NET客户端需要通过WAN连接到远程SQL Server，是否可以压缩客户端和服务器之间的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?

推荐答案

查看 connectionstrings.com 这里为SQL Server 2008，数据库提供程序没有某种类型的压缩方案...您可能需要在不同的端口上编写包装器，通过使用前端，通过该端口发送数据，从那里压缩数据，将其压缩，发送到远程端点，解压缩它，并将其转发到不同的端口实际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}=  -+-----------+

模块将位于两端压缩/ decompressing ...

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

说实话，听起来会涉及到工作，因为Firewall的漏洞必须被打破以允许压缩数据输入和输出...抛出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...

看看我在 Codeproject ，该代码充当流量重定向器，可以轻松地修改为使用压缩/解压缩方案。

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..

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