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?
asked Oct 26, 2009 at 12:34 AM in Default
Steve Jones - Editor ♦♦
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.
answered Oct 26, 2009 at 02:03 AM