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,
RCoTeamAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel_PLDB Expert/ArchitectCommented:
Hi,

https://docs.microsoft.com/en-us/sql/relational-databases/replication/breaking-changes-in-sql-server-replication

Open in new window


I understand this statement includes Distributor. Even if placing distributor on SQL 2016 would work I wouldn't decide to stay on this config for production. Microsoft probably will get back to above mentioned statement in case of any issues.

Regards,
Daniel
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RCoTeamAuthor Commented:
Makes sense, I'll stick with SQL 2012 for the distributor for now.

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.

Thanks for the sanity check,

Matt
0
Daniel_PLDB Expert/ArchitectCommented:
Hi,

After migration to SQL 2014 you can.

Replication is supported if each SQL Server endpoint is within two major versions of the current version of SQL Server.
You can go to SQL Server 2017 if these 2012's will go to 2014 too.

Regards,
Daniel
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.