x

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

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 77 79 82

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

Rob Farley gravatar image

Rob Farley
5.7k 16 18 20

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1840
x474
x305

asked: Oct 26, 2009 at 12:34 AM

Seen: 1602 times

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