Compression in Replication

we are planning to use SQL Server 2000 replication to replicate BLOBs
stored in image, ntext datatypes. Since the size of these BLOBs will
vary and sometimes be quite large, is there any way in which
Replication does compression on the data ?
we are concerned about the bandwidth issues and would appreciate
any insights into this.
Thanks
TJ,
on the snapshot location tab, you can select to plact the snapshot files in
an alternative location. If you do this, there is the option to compress the
files. The compression creates a CAB file which is passed to the subscriber
then decompressed there by the distribution/merge agent before assing to the
subscription database. Apart from the snapshot, I don't know of any way of
compressing data, as it is stored in system tables for transactional and
merge. You might like to look at optimisation of the agent profile to help
with BLOB datatypes.
HTH,
Paul Ibison
|||No, there is no way to selectively compress columns in tables with
replication. There are issues with replicating text and image data type
columns.
Look at Planning for Transactional Replication in BOL for more information.
"TJ" <anonymous@.discussions.microsoft.com> wrote in message
news:E497769F-3B0A-40CA-9937-A314B359F681@.microsoft.com...
> we are planning to use SQL Server 2000 replication to replicate BLOBs
> stored in image, ntext datatypes. Since the size of these BLOBs will
> vary and sometimes be quite large, is there any way in which
> Replication does compression on the data ?
> we are concerned about the bandwidth issues and would appreciate
> any insights into this.
> Thanks
|||Thanks Hilary and Paul.
appreciate your inputs.
|||Normaly Windows to Windows PPP connection does data compression
up to 85%. In cases where we connect Windows servers over ISDN router
and for asome reason they cannot negotiate compression, we are using
OpenSSH + PUTTY , achieving up to 5 times better results than without
compression.
Happy greetings
Pagus
On Thu, 25 Mar 2004 07:01:08 -0800, "TJ"
<anonymous@.discussions.microsoft.com> wrote:

>we are planning to use SQL Server 2000 replication to replicate BLOBs
>stored in image, ntext datatypes. Since the size of these BLOBs will
>vary and sometimes be quite large, is there any way in which
>Replication does compression on the data ?
>we are concerned about the bandwidth issues and would appreciate
>any insights into this.
>Thanks