replication from 2005 to 2012

  • Hi everyone,

    Is it possible to replicate the data from 2005 to 2012?

    Thanks

    Daniel

  • Yes you certainly can replicate from 2005 to 2012. The distributor must be the highest version of each of the database servers participating in replication - in this case it would need to be SQL 2012.

  • Yes, you can replication from a 2012 publication to a 2005 subscriber, so long as the publication is set to have compatibility to 2005 (it will default in the setup to 2012 only).

    2005 is the lowest version for 2012 support though - you can't replicate from 2012 to 2000

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply