sql server migration

Copper Contributor

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

4 Replies
Sure it's possible; why do you ask or do you have doubts?

Olaf
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.
I don't see any problem on this approach.
Setup a test enviroment and give it a try by simply doing it.
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.