Replicate from SQl Server 2008 to SQl Server 2000

Question

Hello All,

I need to know if that possible to replicate from SQL Server 2008 x64 on windows server 2008 R2 to SQL Server 2000 x32 on windows server 2003/08

any help will be appricited 

 

---

Volcano , "DATA is the Focus, Business is the Target”"

Answer 1

Yes, this is entirely possible.

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

Hi,

For transaction replication, a SQL Server 2000 Publisher can have SQL Server 2008 Subscribers, and a SQL Server 2008 Publisher can have SQL Server 2000 Subscribers. For merge replication, a Subscriber to a merge publication can be any version no later than the Publisher version. For all types of replication, the Distributor version must be no earlier than the Publisher version. For more information about using Multiple Version of SQL Server in a Replication Topology, please see http://technet.microsoft.com/en-us/library/ms143241.aspx.

If there are any more questions, please let me know.
Thanks.

---

***Xiao Min Tan***Microsoft Online Community***

Answer 3

thx all for the reply

Xioa, I just tasked to implement above solution , In case face any issue will post it


Thx again

---

Volcano , "DATA is the Focus, Business is the Target”"