November 2, 2007 at 11:19 am
I am in plan to migrate SQL server from 2000 to 2005. How do I take care about transaction replication.
I have distributor in different box.
How shall I do this? shall I do first subscriber and then distrubutar and then publisher or vise-versa any suggestion.
Shall I just use upgrade vizard to do that?
Nita
November 2, 2007 at 11:48 am
I would recommend disabling the replication, do your upgrades, then re-setup replication. You need to configure the distributor first. Look up books online in 2005 for replication setup steps. They have done a very good job in explaining the steps (unlike in 2000). just follow through and you will be good.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
November 2, 2007 at 11:53 am
We have so many subscriber...
Is there is any other way to do replication with upgrade wizard.
Nita
November 2, 2007 at 12:12 pm
Are you doing "In-Place" upgrade or "Side-by-side" upgrade ? I've just done "In-Place" upgrade and I didn't have to do anything for replication. It kept right on working afterwards.
November 2, 2007 at 12:22 pm
We going to do side-by-side upgrade....after we do we going to put same server name.
Nita
November 2, 2007 at 12:32 pm
Could you do "in-place" ?? side-by-side seems like so much more work, but may be required in your situation.
November 2, 2007 at 12:51 pm
Yes it is the requirement to go only side-by side only
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply