Replication setup

  • 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!

  • 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

  • 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?

  • 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

  • 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.

  • 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

  • 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.

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

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