Replication Migration x32 to x64

[JayKusch]

Morning,


Here is the scenario,

Currently have 150+ publications on an x32 SQL 2000 instance.

We plan to migrate to an x32 SQL 2005 instance on the same server.

That part we pretty much have worked out and tested.

The next hurdle is that we will then be migrating the x32 SQL 2005 instance from a server in our West coast DC to our Texas DC.

Issue here is that the server will be an x64 box.

The plan we are discussing now would be to name the new x64 server in TX the same as the server in the West coast DC (we know there are logistics in doing this and are working through those pieces).

We would then snapshot the publications as well as migrate the Master and MSDB DBs from the x32 instance over to the x64 server and fire it up.

That way it would look like nothing really transpired and replication would commence once started back up.

BUT in reality, replication would be now publishing from the x64 server in our TX DC.

QUESTION IS: since the Master and MSDB on the new x64 server are actually the x32 DBs from the old x32 server, will we run into issues?

Is there a way to upgrade the DBs to x64 once in place?

Is there a way to execute the switch we are trying to accommodate? (What we are trying to do is make this move without having to rebuild all the publications and the piece that seems to be the hurdle is the OS going from x32 to x64).

If there are any docs, links or mans that would further help me, by all means please pass them on.

Any and all help is appreciated,

Thanks

J. Kusch

 

[JayKusch]

BOL to the rescue (once you know what you are looking for - lol).

We are going to leverage Replication and Mirroring to make this happen.

Thanks ALL!

Thanks

J. Kusch

 

[mrdenny]

Jay,
I've moved system databases from x86 to x64 without issue.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog