32-bit SQL 2000 publisher and SQL 2005 64-bit SQL distributor and Subscriber

For transactional replication, are there any issues and is it even possible to have 32-bit SQL 2000 publisher and SQL 2005 64-bit distributor and subscriber? Thanks

This is a supported case and should work fine. Remember you have to set everything up in SQL Server Management Studio 2005 as you can not connect to SQL 2005 from SQL 2000 Enterprise Manager. Alternatively, you can use TSQL script to setup replication.

Hope that helps,

Zhiqiang Feng

This posting is provided "AS IS" with no warranties, and confers no rights.