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