Replication from SQL 2008 publisher/distributor to SQL 2000 subscriber

Question

<!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:1627421319 -2147483648 8 0 66047 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:Tahoma; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman"; mso-fareast-language:EN-US;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> Hi Guys

I was wondering if there are any special configs to take into account when configuring replication from a SQL 2008 publisher/distributor to a SQL 2000 database. Currently replication has been setup between SQL 2000 – SQL 2000, but now I want to replicate from a SQL 2008 to a SQL 2000 server, can I use the same replication configuration setting or does it have to conform to new SQL 2008 replication commands etc.


Thanks.

Answer 1

You can take your SQL 2000 publication script and run it in Management studio  on your SQL 2008 publisher. It will give you warnings about what it does not support.

It should work fine.

---

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

In addition to what Hilary already mentioned. It will work without any issue. I have done this at current client place for multiple servers.

Answer 3

Hi,

Please refer to Using Multiple Versions of SQL Server in a Replication Topology:
http://msdn.microsoft.com/en-us/library/ms143241.aspx

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

---

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