Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ettore
Starting Member
5 Posts |
 Posted - 2004-04-07 : 02:58:25
|
| 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'? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-07 : 12:13:47
|
| You can generate the scripts for replication through Enterprise Manager. Right click on your publication and go to generate script. Generate the create and delete script. Modify them as necessary for other servers.Tara |
 |
|
|
Ettore
Starting Member
5 Posts |
Posted - 2004-04-08 : 02:57:12
|
| Thanx, but what to do with the DTS package, which has to be created for the initialization of the sibscriber? I could create it only on the publisher's site, so how to deploy it's creation to the other publishers? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-08 : 11:39:41
|
| I don't know what you mean by DTS package. I know what a DTS package is but it doesn't have anything to do with replication. Please explain this.If you generate the scripts in EM, then you just run the scripts in QA connected to the publishing machine.Tara |
|
|
|
Ettore
Starting Member
5 Posts |
Posted - 2004-04-09 : 02:50:28
|
| Well, I forgot to say that I want to set up the the pull subscription. In this case, in the publication properties window, subsctiptions tab, you are supposed to push the Transformation button and set up the DTS package for the initial snapshot. Anyway that's what is written in all books and articles about the transactional replication in MSSQLSever. |
|
|
|
|
|
|
transactional replication distribution