Upgrade scenario
- From: "Tom" <mcseman2002@xxxxxxxxxxx>
- Date: Fri, 6 Jan 2006 00:23:59 +0100
Current situation:
- 1 central location running SQL 7.0 acting as a publisher and distributor
in merge replication
- 30 remote locations running SQL 6.5 and acting as subscribers
- subscribers are pushing articles to central location twice a day
We are planning to replace all servers with new ones running windows 2003
and SQL 2005.
There is no way we can replace all servers and migrate the databases over
night so we need a scenario where we can replace remote servers one by one
and to ensure that old and new remote locations can replicate with central
location at the same time....
any suggestions??? Thanks
Tom
.
- Follow-Ups:
- Re: Upgrade scenario
- From: Michael Hotek
- Re: Upgrade scenario
- From: Hilary Cotter
- Re: Upgrade scenario
- Prev by Date: Re: Peer to peer replication on SQL 2000?
- Next by Date: Re: Is SQL2005 Database Mirroring ready?
- Previous by thread: Re: SQL 2005 Merge Replication and Locking...
- Next by thread: Re: Upgrade scenario
- Index(es):