September 6, 2005 at 2:30 pm
I have setup a Transactional Publication with Pull subscriptions. The server is Sql Server 2000 and users have MSDE installed. All users should be able to initiate the synchronization when they need it. There is a good example on Replication using ActiveX provided by Microsoft. This is using SqlDistribution and SqlSnapshot objects. I would like to create exactly the same thing using SQL-DMO. I don't want to recreate the publication/subscription, or setup publishers/distributor/subscriber (there is already another example from Microsoft that does that using SQL-DMO object). I just want to somehow run the distributor agent to publish the snapshot, and synchronize the data between publisher and subscriber. I thought TransPullSubscription (or TransPullSubscription2) would be the object to use, but I don't see any method in there that can synchronize data.
Anyone has come accross this problem, or has any idea?
thanks, ej
September 7, 2005 at 4:55 am
Download the code samples in my sig. There are examles of how to do it there.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
September 7, 2005 at 7:42 am
Thanks for your answer Hilary. I downloaded the code samples, and I think I found what I'm looking for in there.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply