Oct 23, 2001 #1 GolfBoy MIS Joined Sep 5, 2001 Messages 35 Location GB We have 2 SQL servers, one is V6.5 and the other is 2000 does anybody know if you can replicate between them?
We have 2 SQL servers, one is V6.5 and the other is 2000 does anybody know if you can replicate between them?
Oct 23, 2001 1 #2 tlbroadbent MIS Joined Mar 16, 2001 Messages 9,982 Location US Yes. You can replicate between 6.5 and 2000 with limitations. The articles at the following links explain how, the requirements and the limitations. Replication Between Different Versions of SQL Server http://msdn.microsoft.com/library/en-us/replsql/replimpl_4joy.asp sp_addpublisher70 http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_repl_2l80.asp Replication and Upgrading http://msdn.microsoft.com/library/en-us/instsql/in_upgrade_45ir.asp Terry L. Broadbent FAQ183-874 contains tips for posting questions in these forums. NOTE: Reference to the FAQ is not directed at any individual. Upvote 0 Downvote
Yes. You can replicate between 6.5 and 2000 with limitations. The articles at the following links explain how, the requirements and the limitations. Replication Between Different Versions of SQL Server http://msdn.microsoft.com/library/en-us/replsql/replimpl_4joy.asp sp_addpublisher70 http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_repl_2l80.asp Replication and Upgrading http://msdn.microsoft.com/library/en-us/instsql/in_upgrade_45ir.asp Terry L. Broadbent FAQ183-874 contains tips for posting questions in these forums. NOTE: Reference to the FAQ is not directed at any individual.