SQL Server 2008 replication to 2012 and viceversa, also with 2005

• Pablo Campanini-336244

  SSC Eights!

  Points: 823

  More actions

  October 4, 2012 at 10:04 am

  #263411

  I could not find a good response on the msdn, but here are my questions:

  Replication: (Transactional)

  Can replication work from SQL 2005 >> 2008?

  Can replication work from SQL 2008 >> 2012?

  Can replication work from SQL 2005 >> 2012?

  I believe it should work backwards. From upper version to lower versions......??

  Thanks

  Pablo;-)

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  October 4, 2012 at 10:57 am

  #1545689

  It will. The only restriction is on certain datatypes and that the distributor needs to be equal or higher to the highest version.

  http://msdn.microsoft.com/en-us/library/ms143241%28v=sql.105%29.aspx