Replication setup

Question

Replication setup

tt-615680

SSCertifiable

Points: 7835
More actions
October 8, 2018 at 2:15 am

#415789

Dear All,
I want to set up Replication between 2 different versions of SQL Server, I want to know how much higher I can go e.g. if I had 2008r2, would I be able to use it with 2016 etc. please?
Thanks in advance!

Viewing 7 posts - 1 through 6 (of 6 total)

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

tt-615680 - Monday, October 8, 2018 2:15 AM
Dear All,
I want to set up Replication between 2 different versions of SQL Server, I want to know how much higher I can go e.g. if I had 2008r2, would I be able to use it with 2016 etc. please?
Thanks in advance!

Some rules here.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

tt-615680 SSCertifiable Points: 7835 More actions · Answer 2

ChrisM@Work - Monday, October 8, 2018 2:26 AM
tt-615680 - Monday, October 8, 2018 2:15 AM
Dear All,
I want to set up Replication between 2 different versions of SQL Server, I want to know how much higher I can go e.g. if I had 2008r2, would I be able to use it with 2016 etc. please?
Thanks in advance!
Some rules here.

Thank you for your reply, so the "Publisher" doesn't need to have a higher version of SQL Server, as it states in some sites?

Sue_H SSC Guru Points: 90860 More actions · Answer 3

tt-615680 - Monday, October 8, 2018 4:23 AM
ChrisM@Work - Monday, October 8, 2018 2:26 AM
tt-615680 - Monday, October 8, 2018 2:15 AM
Dear All,
I want to set up Replication between 2 different versions of SQL Server, I want to know how much higher I can go e.g. if I had 2008r2, would I be able to use it with 2016 etc. please?
Thanks in advance!
Some rules here.
Thank you for your reply, so the "Publisher" doesn't need to have a higher version of SQL Server, as it states in some sites?

The publisher needing to have a higher version than what?
The distributor needs to be on the same version or higher than the publisher.
With transactional replication the subscriber needs to be within two versions of the publisher. It could be higher or lower.

Sue

frederico_fonseca SSCoach Points: 16157 More actions · Answer 4

Sue_H - Friday, October 12, 2018 4:45 PM
tt-615680 - Monday, October 8, 2018 4:23 AM
ChrisM@Work - Monday, October 8, 2018 2:26 AM
tt-615680 - Monday, October 8, 2018 2:15 AM
Dear All,
I want to set up Replication between 2 different versions of SQL Server, I want to know how much higher I can go e.g. if I had 2008r2, would I be able to use it with 2016 etc. please?
Thanks in advance!
Some rules here.
Thank you for your reply, so the "Publisher" doesn't need to have a higher version of SQL Server, as it states in some sites?
The publisher needing to have a higher version than what?
The distributor needs to be on the same version or higher than the publisher.
With transactional replication the subscriber needs to be within two versions of the publisher. It could be higher or lower.
Sue

Hum.. I had transactional setup between a 2016 (publisher and distributor) and a 2008 R2 (subscriber) with no issues.
Maybe just not a setup that Microsoft supports.

Sue_H SSC Guru Points: 90860 More actions · Answer 5

frederico_fonseca - Friday, October 12, 2018 5:53 PM
Sue_H - Friday, October 12, 2018 4:45 PM
tt-615680 - Monday, October 8, 2018 4:23 AM
ChrisM@Work - Monday, October 8, 2018 2:26 AM
tt-615680 - Monday, October 8, 2018 2:15 AM
Dear All,
I want to set up Replication between 2 different versions of SQL Server, I want to know how much higher I can go e.g. if I had 2008r2, would I be able to use it with 2016 etc. please?
Thanks in advance!
Some rules here.
Thank you for your reply, so the "Publisher" doesn't need to have a higher version of SQL Server, as it states in some sites?
The publisher needing to have a higher version than what?
The distributor needs to be on the same version or higher than the publisher.
With transactional replication the subscriber needs to be within two versions of the publisher. It could be higher or lower.
Sue
Hum.. I had transactional setup between a 2016 (publisher and distributor) and a 2008 R2 (subscriber) with no issues.
Maybe just not a setup that Microsoft supports.

If you use t-sql, you can set things up that may not be supported. Being able to set it up doesn't mean it's supported. I think it's the wizard that enforces the versions.

Sue

frederico_fonseca SSCoach Points: 16157 More actions · Answer 6

Sue_H - Saturday, October 13, 2018 6:20 AM
frederico_fonseca - Friday, October 12, 2018 5:53 PM
Sue_H - Friday, October 12, 2018 4:45 PM
tt-615680 - Monday, October 8, 2018 4:23 AM
ChrisM@Work - Monday, October 8, 2018 2:26 AM
tt-615680 - Monday, October 8, 2018 2:15 AM
Dear All,
I want to set up Replication between 2 different versions of SQL Server, I want to know how much higher I can go e.g. if I had 2008r2, would I be able to use it with 2016 etc. please?
Thanks in advance!
Some rules here.
Thank you for your reply, so the "Publisher" doesn't need to have a higher version of SQL Server, as it states in some sites?
The publisher needing to have a higher version than what?
The distributor needs to be on the same version or higher than the publisher.
With transactional replication the subscriber needs to be within two versions of the publisher. It could be higher or lower.
Sue
Hum.. I had transactional setup between a 2016 (publisher and distributor) and a 2008 R2 (subscriber) with no issues.
Maybe just not a setup that Microsoft supports.
If you use t-sql, you can set things up that may not be supported. Being able to set it up doesn't mean it's supported. I think it's the wizard that enforces the versions.
Sue

Probably that then - my solution was all done through t-sql.