Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Is a SQL 2000 publisher possible?

Author  Topic 

TessZA
Starting Member

7 Posts

Posted - 2009-10-12 : 06:06:42
Hi there

Is it possible to set up replication with a SQL 2000 Publisher and a SQL 2008 distributor?

Tx,
Tess

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-10-13 : 15:05:38
Yes.. the only requirement is, distributor should be at least same version as publisher.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2009-11-09 : 12:55:11
A SQL Server 2000 Publisher can have SQL Server 2008 Subscribers. The Distributor version must be no earlier than the Publisher version.

http://technet.microsoft.com/en-us/library/ms143241.aspx

Thanks,
Krishna
www.SQLServer.in
Go to Top of Page
   

- Advertisement -