Hi There
Currently in production we have a publisher, remote distributor, and subscriber all running 2000.
We
want to upgrade the subscriber and possibly the remote distributor to
2005 while leaving the publisher 200 for now, i need a good link or
article about the proper proceudre to accomplish this.
Thanx
2000/2005 Mixed Replication
Hot Topic
SQL Server
- sp_change_users_login
- parallel execution
- sql problem in stored procedure
- Un-detected deadlocks?
- How to run parallely/sequentially
- Reporting Servers - Export to Multiple tabs in Excel
- Cannot get rid of SQL server 2005 Developer Edition Installation
- trigger issues
- A Problems after the install of the Hotfix
- Can fields span TableGroups independantly of columns
2000/2005 Mixed Replication
CengMAT
You may want check following SQL 2005 Books Online topic:
Upgrading Replicated Databases
http://msdn2.microsoft.com/ms143699(en-US,SQL.90).aspx
Please note the recommend upgrade sequence is to upgrade Distributor first, then publisher, then subscriber. The backcompatibility requirement for merge and transactional replication is also different. In general we have distributor version >= publisher version. The final state of your replication setup will be a mixed version environment, thus following topic will be helpful:
Replication Backward Compatibility
http://msdn2.microsoft.com/ms143323(en-US,SQL.90).aspx
Using Multiple Versions of SQL Server in a Replication Topology
http://msdn2.microsoft.com/ms143241.aspx
Hope that helps,
Zhiqiang Feng
This posting is provided "AS IS" with no warranties, and confers no rights.
MayBoy