Showing posts with label ordo. Show all posts
Showing posts with label ordo. Show all posts

Wednesday, March 21, 2012

Mixing SQL 2000 and SQL 2005 replication

Does anyone know if a 2005 server can replicate data with a 2000 server or
do they all have to be 2005.
Thanks in advance
Martin
Never mind yes it can.
Martin
"Martin McNally" <martinmcnally@.gmail.com> wrote in message
news:%23sZvOazdFHA.3048@.TK2MSFTNGP12.phx.gbl...
> Does anyone know if a 2005 server can replicate data with a 2000 server or
> do they all have to be 2005.
> Thanks in advance
> Martin
>
|||Martin,
there are loads of caveats for this scenario eg logical records, partitions
etc - have a look at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/45154b65-b46f-4aad-82e4-261376a7e9d4.htm
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql