Moving publisher db to another server. (any steps on how to do this without reinitializing

I will be doing this all via EM since I don't know much about sql. I
want to move a db that is being published on one server to another. I
will configure them both to use the same distributor so I am pretty sure
this is possible.
tia
-comb
Will the other server have the same name? If not, then unless you are going
to hack the entries in replication system tables, you have to reinitialize.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||In article <uhQ7aK1wFHA.3720@.TK2MSFTNGP11.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> Will the other server have the same name? If not, then unless you are going
> to hack the entries in replication system tables, you have to reinitialize.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
no it will be moving from instance vsql13/ep01 to vsql22/ep03. Can, I
not just move the db over and check or uncheck the box that says
"subscriber already has schema/data"?
Thanks for the response paul!
-comb
|||Comb,
ah - I misunderstood you . I was thinking you were talking about taking
the publication as well. If you're recreating the publication, then doing a
no-sync initialization should be ok. Still, I'd script the stored procs,
remove the remnants of replication on the subscriber first using
sp_removedbreplication, then script back in the stored procs.
Cheers,
Paul
|||In article <ugiD#T4wFHA.2232@.TK2MSFTNGP11.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> Comb,
> ah - I misunderstood you . I was thinking you were talking about taking
> the publication as well. If you're recreating the publication, then doing a
> no-sync initialization should be ok. Still, I'd script the stored procs,
> remove the remnants of replication on the subscriber first using
> sp_removedbreplication, then script back in the stored procs.
> Cheers,
> Paul
>
>
Man you are talking to a network guy forced into a sql enviroment
because i can spell sql. hehe. Do you have instructions on how to do
this on your website? http://www.replicationanswers.com
I will use BOL to see if i can figure out how to run
sp_removedbreplication.
Effectivly what I am doing is what you are describing. I will be
dropping replication from the current db. Detatching that db from one
server and move it to another server, and then recreating the
publications. I can do this the 1 way like you said where I script out
the pubs before I delete them. Then edit what I need to in those
scripts and run them on the new server. However, I would have to know
where in the sql script to tell replication that the subscriber already
has everything. I do not know sql well enough (at all really) to do
this.
Will doing it in the gui (EM) give me the same result? I have seen like
two area's where it looked like an option not to do a new snapshot. One
place is under where you choose with table you are going to choose for a
certain publication. In there there is a little ... box to click and i
think inside there you can choose "subscriber already has data". Then
also I think some where in the wizard you can choose something to the
same effect. like the 2nd picture in this article on your site.
http://www.replicationanswers.com/No...alizations.asp
Thanks for all your help.
-comb
|||Comb,
you're definitely almost there - it's the option "No, subscriber has already
has the schema and data" that you'll need (nosync initialization).
( http://www.replicationanswers.com/No...alizations.asp)
Cheers,
Paul Ibison
|||In article <ehh0wy6wFHA.3892@.TK2MSFTNGP12.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> Comb,
> you're definitely almost there - it's the option "No, subscriber has already
> has the schema and data" that you'll need (nosync initialization).
> ( http://www.replicationanswers.com/No...alizations.asp)
> Cheers,
> Paul Ibison
>
>
ok cool thanks for the responses as usual. Wish me luck!
|||You won't need it - it's easy
Cheers,
Paul
"combfilter" <asdf@.adsf.com> wrote in message
news:MPG.1da4cc05bcaa7b979896bf@.news.newsreader.co m...
> In article <ehh0wy6wFHA.3892@.TK2MSFTNGP12.phx.gbl>,
> Paul.Ibison@.Pygmalion.Com says...
> ok cool thanks for the responses as usual. Wish me luck!
>