April 7, 2004 at 12:54 am
Hi!
We've just set up the transactional replication on 2 sql servers: one - the publishing distributor (enterprize edt), the other - subscriber (desktop edt). The subscription is of type push. The question is if there is any way to distribute the 'replication package' in order to set the same replication on the other publishing server (the subsriber will be always the same). I.e. we have three servers in three regions with one publication db on each and we need to replicate the data from each of those db to the corresponding subscribtion db on the fourth server. Can we prepare the 'pack' and distribute it to those three servers admins for the 'pack' to be 'installed'?
April 7, 2004 at 8:17 am
You want to set up replication on other servers (B & C) that's the same as what you have now (server A)?
If you just want to copy the publication, you can script it out (right click, generate script) then cut & paste the script to servers B & C and run the script to create new publication there that are the same as "A"
April 8, 2004 at 12:36 am
Yeah. that's it. The only problem is the DTS package. As far as I understand, it is needed only for the subscription initialization, right? And can be created at the subscriber's site? The subscriber is always the same so I need just to run the scripts on the publisher's site, right?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply