Can I replicate from SQL 2000 to SQL 2005?

If I have an existing SQL Server 2000 instance and want to replicate some sales data to a SQL Server 2008 instance, is that possible? Can I use all three types of replication?

more ▼

asked Oct 26, 2009 at 12:34 AM in Default

avatar image

Steve Jones - Editor ♦♦
5.2k 79 94 87

SQL 2005, or SQL 2008? The title says 2005, and the question says 2008.

Oct 26, 2009 at 02:04 AM Rob Farley
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Yes you can, but you'll be limited to features that are available in SQL 2000. A publisher that is SQL 2000 can happily talk to a subscriber that is SQL 2008, but if you're using Merge Replication, the SQL 2008 subscriber should have its compatibility level set to SQL 2000 to make it work.

This setting wasn't available in SQL 2005, so having SQL 2000 and SQL 2005 talk to each other using Merge Replication was problematic. SQL 2008 understands that there are a lot of SQL 2000 boxes still out there, and has made this possible.

more ▼

answered Oct 26, 2009 at 02:03 AM

avatar image

Rob Farley
5.8k 16 22 28

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 26, 2009 at 12:34 AM

Seen: 1839 times

Last Updated: Oct 26, 2009 at 12:34 AM

Copyright 2018 Redgate Software. Privacy Policy