April 8, 2004 at 12:55 am
Transactional replication: we have the publisher with anonymous subscribtions allowed and the subscriber. But for the subscriber to be initialized the publisher has to create a DTS package in which the subscriber has to be set up. At the subscriber I couldn't create such DTS package. The question is what for to allow anonymous subscribtions if in DTS I must specify the subscriber explicitly?
April 12, 2004 at 8:00 am
This was removed by the editor as SPAM
April 16, 2004 at 2:11 pm
The subscribers are SQL Server?
Why do you need to use DTS? Can you use pre and post Snapshot Application Scripts?
April 19, 2004 at 1:06 am
Well, I set up the trans. replication through the SQL Server replication wizard. It creates the initial snapshot when setting up the publication and the DTS package when setting up the subscription. Is there any way to bypass the DTS? Could you, pls, be more detailed?
April 19, 2004 at 7:04 am
DTS package in replication are to transform the repliated transactions when you are replicating to heterogeneous subscribers, like Oracle.
If you don't need to transform your data, then you shound't use DTS.
When creating the publication with the wizard, in the Transform Published Data, specify No, subscribers receive data directly.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply