If I have an existing 64bit P2P transactional replication setup, can I join
a 32bit machine without any expected problems or does it also have to be a
64bit machine?

Any direction to resources would be great as well.

Adam P. Cassidy

Adam,

For SQL Server 2000, the issues were summarised as follows:

As the Microsoft Jet engine is not supported, Microsoft Jet push
subscriptions for merge replication are not supported.
Unless the subscriber provides a 64-bit ODBC or OLE DB driver, transactional
or snapshot push subscriptions for ODBC or OLE DB subscribers are not
supported.
Because of the unavailability of 64-bit Data Transformation Services (DTS),
transformable push subscriptions are not supported.

In Peer-to-peer between 64bit and 32bit I am therefore aware of no issues.

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

This is a tested configuration


[quoted text, click to view]