Forum Discussion

Alex_Kim245's avatar
Alex_Kim245
Copper Contributor
Jul 06, 2022

sql server migration

Is that possible to migrate databases on sql server 2016 to 2019 with mirroring or replication.

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Jul 07, 2022
    Sure it's possible; why do you ask or do you have doubts?

    Olaf
    • Alex_Kim245's avatar
      Alex_Kim245
      Copper Contributor
      Jul 07, 2022
      Thanks. The reason I'm asking is current server is Windows 2016 and new server will be Windows 2019. So not just sql server version change but also OS version change.
      • isaaclewis's avatar
        isaaclewis
        Copper Contributor
        Jul 18, 2022
        This should be fine -- one caveat is that the publishing server *must* be at least Standard Edition. Web edition does not support publication for replication/mirroring.

Resources