November 8, 2007 at 12:42 pm
We are migrating SQL from 2000 to 2005.
I migrated Subscribers from 2000 to 2005 and the replicaiton is not working on that subscriber. I checked the password can someone please give me there feedback
Nita
November 8, 2007 at 7:43 pm
Hi
Can you tell us that Publisher having which version of SQL Server?
Thanks & Regards
Rajni Kant Ranjan
Senior SQL DBA
November 8, 2007 at 11:21 pm
Search around a bit through the user sites / blogs, but as I recall, distributor is the critical component here to have as 2005. Someone out there has a great website regarding SQL replication, and I've lost it.
For instance:
If I currently have a publisher and distributor on 2000, and want to upgrade subscribers to 2005... it is necessary for distributor to be of equal or greater versions that subscribers. We are working on this ourselves. In our case, we have test enviroments to set up play senarios.
Several of our subscribers are planning on upgrading to 2005 before our publisher/distributor combo. I'm considering separating distributor as 2005 and from what I read so far, this will work.
Sorry if not accuate, as I can't reference anything, but I think/hope so
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
November 9, 2007 at 7:09 am
Publisher has SQL 2000
November 9, 2007 at 10:40 am
What is the error messege you are getting?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply