Avatar of RCoTeam
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

SQL Replication, versions??

I need to replicate a Database hosted on a SQL 2005 server std (Publisher) to SQL 2012 server std (Subscriber), I understand that there is no issue there because they are 2 major releases apart.

I wish to use a separate Distributor Server for performance, what version can be used here.  I can't seem to find this documented for my scenario.  I would use 2016 if possible?

The replication type is most likely to be snapshot.

Many thanks,

Avatar of undefined
Last Comment

8/22/2022 - Mon