• Not Answered

Migrate sitecore DB from sql server 2014 to sql server 2016 sp2

Hi,

I am looking for help to handle the below scenario in best or recommended way..

 

Scenario: 

On my dev machine , my existing project in working state is using sitecore 8.1 update 3 with SQL server 2014.

On the same machine, I installed sitecore 9.3 with SQL server 2016 sp2. Sitecore 9.3 instance is working fine because it meets all the prerequisites.

 

I am looking for a way to move sitecore 8.1 database like master core web from sql server 2014 to SQL server 2016.

 

What am i thinking about is to first somehow i upgrade sitecore 8.1 DB for sitecore 9.3 , create back up  and restore it to sql server 2016. Not sure, how will i make it happen if it is best way.

 

Please suggest some direction how to do it. 

 

Thanks

Rajesh