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
Can I replicate from SQL 2000 to SQL 2005?
SQL 2005, or SQL 2008? The title says 2005, and the question says 2008.
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.
