October 22, 2008 at 1:23 am
That is a question probably to replication masters,
I'm going to upgrade/migrate database server that is at the moment 32 bit version of SQl 2005 Ent. with SP2 to the new server 64 bit one.
I know that only good way is to build new server then copy database across and start db under new 64 bit version.
I also capture things like re-create users, their permissions & jobs. But my concern at the moment is replication.
Sql Server replicate some articles to other DB sources with transactional replication and pull subscriptions.
Is is possible to re-setup replication on new server without initialize it once more from the begining ?
Reason for that question is bescouse I do not have enought outage time to complete replication rebuild.
Do you see any other things that I should be aware of when move 32bit to 64bit ?
(there was probably a lot of posts about that)
October 22, 2008 at 11:26 am
Based on what you said I assume you're only talking about publications where your server that you're migrating is the publisher, not where it's the subscriber. If you can ensure that your x86 and x64 servers are in synchronization with one another (e.g. take a differential backup from your x86 server and apply to your x64 server, or use log shipping) and that no data will change while you're making the move, this is possible. Script out your publications ahead of time so you have them ready to apply once you've got the x64 server up. Drop the subscriptions to your x86 server but do NOT select the option to remove the subscription info on the subscribers, then re-establish all your subscriptions on the x64 server without initialization. If you're scripting it, you'll use "@sync_type = N'none'" in your call to sp_addsubscription. If you're doing it through the Subscription Wizard, make sure the checkbox for "initialize" is NOT checked on the "Initialize Subscriptions" window.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply