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.
    • olafhelper's avatar
      olafhelper
      Bronze Contributor
      Jul 08, 2022
      I don't see any problem on this approach.
      Setup a test enviroment and give it a try by simply doing it.

Resources