October 8, 2018 at 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!
October 8, 2018 at 2:26 am
tt-615680 - Monday, October 8, 2018 2:15 AMDear 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.
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
October 8, 2018 at 4:23 am
ChrisM@Work - Monday, October 8, 2018 2:26 AMtt-615680 - Monday, October 8, 2018 2:15 AMDear 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?
October 12, 2018 at 4:45 pm
tt-615680 - Monday, October 8, 2018 4:23 AMChrisM@Work - Monday, October 8, 2018 2:26 AMtt-615680 - Monday, October 8, 2018 2:15 AMDear 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
October 12, 2018 at 5:53 pm
Sue_H - Friday, October 12, 2018 4:45 PMtt-615680 - Monday, October 8, 2018 4:23 AMChrisM@Work - Monday, October 8, 2018 2:26 AMtt-615680 - Monday, October 8, 2018 2:15 AMDear 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.
October 13, 2018 at 6:20 am
frederico_fonseca - Friday, October 12, 2018 5:53 PMSue_H - Friday, October 12, 2018 4:45 PMtt-615680 - Monday, October 8, 2018 4:23 AMChrisM@Work - Monday, October 8, 2018 2:26 AMtt-615680 - Monday, October 8, 2018 2:15 AMDear 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
October 13, 2018 at 6:59 am
Sue_H - Saturday, October 13, 2018 6:20 AMfrederico_fonseca - Friday, October 12, 2018 5:53 PMSue_H - Friday, October 12, 2018 4:45 PMtt-615680 - Monday, October 8, 2018 4:23 AMChrisM@Work - Monday, October 8, 2018 2:26 AMtt-615680 - Monday, October 8, 2018 2:15 AMDear 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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply