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

Replication : Sybase - SQL Server;

Hi all,
Have anyone done the replication between Sybase and MS SQL server ?
Could you please let me know the efficient way to 'PUSH' data from Sybase to MS SQL server or 'PULL' data into MS SQL server from Sybase.
Thanks,
Hari Haran ArulmozhiThe company I used to work for used the Sybase Replication Server product to replicate data from a Sybase source to a Microsoft SQL Server target. We never had any problem with it, but it did require the Sybase Replication Server product, which was fairly pricey.

I know there were third party heterogeneous replication products out there, but most of them required modification to either the source database to add triggers or 'change tables'. That may have changed since I last looked at this at the turn of the century.|||Contact your Sybase sales rep. They'll give you a quote for Replication Server (roughly $50,000 US per sever the last that I knew), and should also offer you training options based on your location.

-PatP