February 5, 2007 at 11:57 am
We need to migrate two of our 2000 SP4 servers (Win 2000 Adv'd Server SP4) to 2005. What I would like to do is create a new 2005 server and then migrate the 2000 user databases in steps over to the 2005 server.
There is one architectural issue though: I really need to replicate from an administrative database on the 2000 server to a clone database on the 2005 server until the migration is complete.
Is there a way to do this in 2005?
When I read in BOL it does not, at least from what I have seen yet discuss how to handle 2000 to 2005 (or vice versa for that matter).
February 5, 2007 at 3:25 pm
Am not sure if you can set up replication from 2000 to 2005. Perhaps TLog shipping can be of interest to you until your migration is complete?
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
February 5, 2007 at 4:14 pm
I've got a 2000 database that is replicated (simple snapshot) to three other 2000 servers. Are you suggesting that on top of that I can log ship that same database to a 2005 server?
February 5, 2007 at 8:11 pm
I have just created a transactional publication (of table Customers in Northwind) on a SQL 2000 instance and created a push subscription to a SQL 2005 instance. The initial snapshot and subsequent updates are applied to the replica.
However, I would recommend that you test with your databases/applications before committing to it.
Normally, you have the distributor at the highest version/service pack (which I did not do but it worked).
February 5, 2007 at 8:50 pm
Thx!
February 6, 2007 at 6:17 am
I have been running transactional replication from a 2000 server to a 2005 server for several months now and I have had no issues. The replication wizard in 2000 handled it just fine and both servers seem ok.
February 6, 2007 at 9:38 am
Thx! That's what I was hoping to hear - I'll start some testing.
February 13, 2007 at 12:57 pm
This is great. I was Just searching for advice on this very topic. I have a Prod that needs migration but cannot come down (global client population).
I'm gonna start testing right away (meaning when people stop pestering me with query requests).
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply