Mark D Allison


Hi,

I have a server in our central location which is a compressed snapshot publisher. I have 2 push subscribers in remote locations on very slow WAN links. I would like the snapshot cabinet file to be uncompressed at the subscribers location rather than the publisher location. Is this possible with push subscribers I want to manage the pushing of data to the remote subscribers from the publisher location.

I understand the default with push subscriptions is to uncompress the cabinet file at the publisher location.

Thanks,
Mark.



Re: Compressed snapshot with push subscribers

Hilary Cotter


In SQL 2000 you don't really have much options for push. For pull you can specify an alternate snapshot location in sp_addpullsubscription.

In SQL 2005 you can initialize from a backup.

Note that your compressed files must be less than 2 Gigs which is the limit for the CAB files.

You are correct that the default is to have them decompressed on the publisher/distributor with push.







Re: Compressed snapshot with push subscribers

Mark D Allison

Hilary you rock - you are right I don't have many options, so what I did was to create a SQLAgent job to dump the files using bcp and then zip them with gzip. On each subscriber server I created a job to copy the files from the publisher, gunzip and bcp in. This job can be invoked from the publisher.

Thanks for your help.
Mark.