June 18, 2003 at 11:33 am
I'm trying to create an anonymous pull subscription to a transactional publication. Does anyone know if you can define a sync_type = 'none' for an anonymous pull subscription?
This option (No, the subscriber already has the schema and data) is "grayed-out" in Enterprise Manager for anonymous pull, but IS available for named pull. I also can not find any reference to a nosync option in the sp_addpullsubscription procedure.
I can work-around by letting it apply the snapshot, then receating the subscriber tables with the correct structure, but it will be much more elegant if I can just select the nosync option.
Thanks in advance,
Brian
June 18, 2003 at 4:22 pm
no you can't use the none parameter with sync_type in anonymous subscriptions.
Anonymous susbcriptions where created for replication over internet, so, usually the subscriber, wich you don't know from what machine can come, don't have the data.
You will still have to create the snapshot. Or change to named subscriptions and then here you can by pass the creation of the snapshot.
Also if you don't want to apply the snapshot to your subscribers, you can "clean" all the snapshot files (.bcp, .idx, .sch). I mean, deleting all the data inside the files and leave the file with a size of 0 bytes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply