We currently have a SQL2000 replication in place and we're considering
moving one of the servers to SQL2005 x64.
is 2000/2005 replication interoperable?.
is the x64 2005 different in handling replication or is it interoperable
with 32bit versions?(be it 2005 x64 to 2005 32b or 2000 32b)
thanks in advance
Guillermo,
for the question about using different versions, please see:
http://msdn2.microsoft.com/en-us/library/ms143241(en-US,SQL.90).aspx.
For the other part, a MS developer recently pointed out that 64-bit and
32-bit are nearly interoperable, but 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.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||if transactional and push replication aren't supported, then what
replication methods do i havce left?
i'm not using jet replication, but push between remote servers across a VPN
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ORH3Utc9FHA.3208@.TK2MSFTNGP11.phx.gbl...
> Guillermo,
> for the question about using different versions, please see:
> http://msdn2.microsoft.com/en-us/library/ms143241(en-US,SQL.90).aspx.
> For the other part, a MS developer recently pointed out that 64-bit and
> 32-bit are nearly interoperable, but 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.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Guillermo,
I have no way of testing this, but pull subscriptions and merge would seem
to be ok. If you give it a try please let us know how it works out.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||i've been told we're using merge subscription, so there would be no problem
with sql 2005 64 to sql2000 it seems
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23FE0coo9FHA.2676@.TK2MSFTNGP15.phx.gbl...
> Guillermo,
> I have no way of testing this, but pull subscriptions and merge would seem
> to be ok. If you give it a try please let us know how it works out.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment