We have a 32-bit edition today and want to secure the uptime by adding a cold
standby.
We want to purchase a new 64-bit machine with the 64-bit editions of OS/SQL.
The 64-bit should replicate data to our "old" 32-bit machine.
I have not found any information on MS-site about this, is this possible?
Will it work just to the same way as replicating between two 32-bit
enivironments?You should be able to replicate between 32 bit and 64 bit SQL Server
editions. I have a scenario where distributor is 64 bit and publisher and
subscriber are 32 bit. It is working fine, and is transparent.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Patrik" <Patrik@.nospam.nospam> wrote in message
news:4F9BA96C-F9AA-4C6E-BD30-391CD75F666A@.microsoft.com...
We have a 32-bit edition today and want to secure the uptime by adding a
cold
standby.
We want to purchase a new 64-bit machine with the 64-bit editions of OS/SQL.
The 64-bit should replicate data to our "old" 32-bit machine.
I have not found any information on MS-site about this, is this possible?
Will it work just to the same way as replicating between two 32-bit
enivironments?|||Hello,
I suggest that you refer to the following information:
Features Supported by the Editions of SQL Server 2000 (64-bit)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sql64/in_pr
eparing64_6184.asp
You can refer to the "Replication Features Supported by the Editions of SQL
Server 2000 (64-bit)" section.
advantages of a 64-Bit Environment :
http://www.microsoft.com/sql/64bit/productinfo/SQL64bitAdvantages.asp
--
Replication
The Replication features of SQL Server 2000 (64-bit) are nearly identical
to the 32-bit version, with the following features being supported:
" Snapshot Replication
" Transactional Replication
" Merge Replication
" Immediately updating subscribers
" Queued updating subscribers
However, there are a few special cases:
" 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 addition, the 64-bit versions of Windows Server 2003, Enterprise Edition
and Windows Server 2003, Datacenter Edition do not include certain features
that are included in the 32-bit versions of those operating systems.
These features are not included because of underlying differences between
the 32-bit and 64-bit architectures or because the features are not
appropriate in the environments where the 64-bit versions of Windows Server
2003, Enterprise Edition and Windows Server 2003, Datacenter Edition are
deployed.
For a complete list of differences, see "Differences Between 64-bit and
32-bit Releases (64-bit)" in SQL Server 2000 (64-bit) Books Online and
"Features unavailable on 64-bit versions of the Windows Server 2003 family"sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment