replication and upgrade of SQL7 to SQL2000

Hi all,
We are preparing to upgrade from SQL 7 to SQL 2000 and we have transactional replication running from this server to Sybase 12.5. We also have couple of batch jobs puling data from Sybase and Oracle to this SQL & server. I'd like to here your experience a
bout moving from SQL7 to SQL2000, especially with replication upgrades. What should be our major concern about the whole upgrade?
Thanks very much
I have migrated many SQL 7 to SQL 2000 servers which have been publishers/subscribers/distributors.
The correct upgrade sequence is update the distributor, publisher and then subscribers (you won't have to do this in your case).
I had no problems with the upgrades, but had a few while applying SP3 - which really is essential when running SQL 2000.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||What is actually the major change in replication of the SQL server 2000?
|||SQL Server 2000 builds upon SQL 7 replication. It offers enhanced performance and greater functionality as well as new functionality. Check out replication enhancements in BOL for more details.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html