Data communication compression?

Hi,
Do you know if there is any tool which can compress the trafic between a
client and an SQL server?
I really talk about communication compression NOT storage compression.
We have some remote sites with a low bandwidth and they have to upload some
data every week. its too slow today.
so if there is no option to compress the communication himself, I'll change
the strategy to export, zip, and copy the file. but this method add a layer
of complexity in the process so I prefer to not do this.
thanks for your guides.
Jerome.On Jun 11, 2:15 pm, "Jeje" <willg...@.hotmail.com> wrote:
> Hi,
> Do you know if there is any tool which can compress the trafic between a
> client and an SQL server?
> I really talk about communication compression NOT storage compression.
> We have some remote sites with a low bandwidth and they have to upload som
e
> data every week. its too slow today.
> so if there is no option to compress the communication himself, I'll chang
e
> the strategy to export, zip, and copy the file. but this method add a laye
r
> of complexity in the process so I prefer to not do this.
> thanks for your guides.
> Jerome.
Hi Jerome
This would be something done at the lowest network layers as the
actual format of the packets needs to be the same for SQL Server to
understand them.
If you are doing a total data refresh then to cut down what you
transfer you may want to consider only distributing a differences. If
the data is rarely queries and response then maybe something like
using SOAP may be an alternative to your database.
John