<div>
Makes sense, I'll stick with SQL 2012 for the distributor for now.<br />
<br />
This is only a stepping stone requirement, the DB hosted in SQL 2005 is going to 2014 shortly, I guess a new distributor can be introduced following that.<br />
<br />
Thanks for the sanity check,<br />
<br />
Matt
</div>


<div>
Hi,<br />
<br />
After migration to SQL 2014 you can.<br />
<br />

<blockquote>
Replication is supported if each SQL Server endpoint is within two major versions of the current version of SQL Server.
</blockquote>
You can go to SQL Server 2017 if these 2012's will go to 2014 too.<br />
<br />
Regards,<br />
Daniel
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
I wish to use a separate Distributor Server for performance, what version can be used here. &nbsp;I can't seem to find this documented for my scenario. &nbsp;I would use 2016 if possible? <br />
<br />
The replication type is most likely to be snapshot. <br />
<br />
Many thanks,
</div>
</div>


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,

SQL Replication, versions??

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.