Content database upgrade from SharePoint 2013 to SharePoint 2016

[@jamesyoung7515]

Hi Shane Thanks for the great video collection. They were really helpful! Do you have any recommendations on how to migrate workflows (definitions and instances) from a SP 2013 site to a SP 2016 site (with WF manager 2010 and 2013 support)? Thank-you

[@ShanesCows]

Hey James, I haven't done that stuff in YEARS. If you want to Tweet me @shanescows I can try to connect you with someone to help. Or if you email me shane at powerapps911 I can connect you with someone else that way. Sorry, I am no help here anymore.

[@chsreenuvas]

Hi Shane, Great session. could you please suggest in case of WSPs present in sp2013...do we need to install them first in sp2016 and attach DB OR after attaching DB in sp2016 do we have to install WSPs...please suggest.

[@ShanesCows]

Been a long time but I usually installed the first.

[@EgzVisualVirtuoso]

Hi Shane. Very simple and easy to follow video. I just have one question. I did all the steps and my test-spcontentdb success and mount-spadmincontentdb success. However, I expect a site count to 1, but it's showing zero. 0 site count. What will be a issue here.

[@ShanesCows]

It is has been too many years for me so I am no help, sorry. Hope you figure it out. Start by checking the logs. My guess is the site didn't upgrade for some reason.

[@EgzVisualVirtuoso]

Thanks for the reply.

[@prashantbeldar7024]

hi Shane! nice video! can you please provide the steps for how to upgrade the service applications databses to 2016 share point server like this cross domain scenario.

[@duffmandje]

Hi Shane, first of all huge thanks for all your videos. I've got a question: one thing I'm not clear about, is whether or not we should use the same approach for app services DB's such as Managed Metadata Service, Search Service, Usage etc... or should I just create new ones and replicate any settings and let SP do its thing, many thank :-)

[@ShanesCows]

It is up to you. If there is meaningful info then upgrade them, if you can easily recreate then I prefer new databases. :)

[@duffmandje]

@@ShanesCows thanks

[@lisbea2568]

Thanks Shane. Great video. The mount-spcontentdatabase may take days for big content databases, but the business won't be happy to wait for SharePoint for days. Do you have any advice to help this process shorter/faster?

[@ShanesCows]

A lot of people end up using a migration tool like ShareGate so they can move things over in a less "all at once" process.

[@lisbea2568]

@@ShanesCows Thanks Shane.

[@danielengland]

Very good video. Was very useful instrumental in the conversion process. It is hard finding guides that are fully Share Point 2016. The only thing I have noticed after change over is that the personal sights are not acting right. They act like they have not been initialized before and get stuck on the initializing phase. (This includes one drive also) Any ideas?

[@ShanesCows]

No. :( I haven't done personal sites for 2016 yet. I will try it out this week and see what I can find out. If you figure it out let us know.

[@marioramos5384]

If you have the time, can you do an updated version using content matrix and demonstrating a migration from classic page to a modern page?

[@ShanesCows]

That would be an awesome video

[@zoltar14102008]

Shane , great video as always , would this work for Multiple Contents , we have 5 DB's one in for each country in our Sharepoint 2013 On Prem Farm? Would you transfer/import all the Db's ?

[@ShanesCows]

Yes if I follow your question. I have used this for 100s of DB in the same farm.

[@amardeeprana82]

Hi , I am upgrading SharePoint 2013 to 2016. DB is upgrading for 30 hours and completed 55 % and still running. DB size is 700 GB. Please sggust.

[@ShanesCows]

That is a really big database. Not surprised it is still chugging away. Sorry, I don't have any magic buttons.

[@arvinbonggal5443]

Do you have a video on migrating My Site? is it the same process with migrating Portal? Thank you in advance

[@ShanesCows]

I don’t but it is.

[@danilogonzalez7903]

hello, where all the done in sharepoint are lodged in which database and how to access it

[@ShanesCows]

Most of the upgrade logs are on the C drive.

[@HamadAbdulla_7]

can you show how to upgrade mysite .... i upgrade Content database all site show in 2019 all good here ... but OneDrive for the User is empty

[@ShanesCows]

Have to migrate your users. Sorry I don’t have a video to help.

[@rikedixon8048]

Hey, Do you have an advance workflow video?

[@ShanesCows]

Not advanced. Email me with what you are looking for.

[@tauseefahmad2011]

We copied the backed-up folder from SQL 2013 server; and pasted it directly into different SQL 2016 server. I was wondering how is that possible? Anyone help please!!

[@ShanesCows]

The MDF and LDF files are a known format. So when you attach to them with SQL Server it does what to do with them. The SQL team has done a great job making things like that go very smoothly. 😎

[@tauseefahmad2011]

@@ShanesCows Thank you mate!

[@samshepherd6197]

what is the link to building the SharePoint farm you refered too?

[@ShanesCows]

kzbin.info/aero/PLCGGtLsUjhm1TKCCVKYvoBs1duaqfCC76 a whole playlist to go through the process

[@michaelross6281]

can you do an in place upgrade of 2013 foundation to 2016 foundation?

[@ShanesCows]

I don’t think so.

[@hossamalmokhlsany7068]

@@ShanesCows i think there's no foundation version for SP2016, isn't it?

[@ThanguTech]

Very nice..Thank You.

[@newabyuser]

are you going to do Installing SharePoint 2019 videos?

[@ShanesCows]

I am not. Sorry. They 2016 is 99% the same.

[@snrguptha]

Upgrading Content DB from 2013 to 2016 is enough or do we need to migrate/upgrade each site from 2013 to 2016 , if yes then how?

[@ShanesCows]

You don’t have to migrate the sites. Up to you. You can automate it with PowerShell

[@tauseefahmad2011]

@@ShanesCows : Hello Shane. First of all, thank you so much for your helpful videos. Just have a quick clarification. So, this is how we can actually migrate all the sites from SharePoint 2013 to 2016 and I believe same can be used for any type of SharePoint migration. Please confirm if my understanding is correct for the steps followed. 1. In SQL 2013, create a back-up of WSS_Content DB 2. Copy the back-up and move that back-up to SQL 2016 server folder 3. Restore the same 4.Test and mount the database

[@Next1On67]

Hi Shane. Followed you step by step, but when I go to RESTORE, I get this error:===================================Restore of database 'WSS_Content_SP2013BK' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)------------------------------ Program Location: at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context) at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.Perform(ITaskExecutionContext context) at Microsoft.SqlServer.Management.TaskForms.TaskExecutionManager.ExecuteTaskSequence(ISfcScriptCollector collector)===================================System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.SmoExtended)------------------------------ For help, click: go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=13.0.16106.4+((SSMS_Rel_16_5).170125-2137)&LinkId=20476------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.RestorePlan.Execute() at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context)Hope you can help. Thanks.

[@ShanesCows]

Haven’t seen that before. Looks like something has the database locked. Maybe a SQL job.

[@mangatram2766]

Does it require Visual Upgrade once Mount Content Database finishes as in Sharepoint 2010- 2013 Migration we used to do Visual Upgrade?

[@ShanesCows]

+Mangat Ram Nope. That is gone.

[@mengenmeng5057]

Super! Thank you very much.

[@ShanesCows]

Glad it helped you.

[@iqbalkmk]

I tried to upgrade from sp2013 to 2016 but its failed . I installed sp2016 and I restored 2013 content database to 2016 db server. Then i tried to test content db using powershell command. Its giving error like the content db is not available. I tried to mount content db its also giving error like this Mount-spcontentDatabase : Exception of type 'Microsoft.Sharepoint.Upgrade.SPUpgradeException' was thrown

[@ShanesCows]

I would check permissions on the SQL database.

[@iqbalkmk]

I checked the permission and give dbowner now the other errors is coming like missing feature , missing Assemble .missing webpart etc.

[@ShanesCows]

That can be normal. Did you have a highly customized 2013 environment? Test gives you an accurate list of the things missing on the 2016 server.

[@jcpa023]

Can i use PWA 2013 server in SharePoint 2016 ?

[@ShanesCows]

I have never tried but I do not believe so.

[@WendyNaty]

I did the migration from sharepoint 2010 to sharepoint 2013 and everything works well but when I tried to do the migration from sharepoint 2013 to 2016 I got many errors related with missingWebPart, I already installed my features on the server but I got this error: WebPart class [dc8d37bf-5afb-657e-e673-6c9328f9c912] (class [Microsoft.SharePoint.WebPartPages.BlogYearArchive] from assembly [Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c]) is referenced [12] times in the database [WSS_Content_96efc9fec58f4920a5949c0ace5a0c78], but is not installed on the current farm. could you help me please? Thanks

[@ShanesCows]

Hi Wendy - Is the error upgrade blocking? Does the site with Blog not work post upgrade?

[@WendyNaty]

Hi Shane Young, thaks for answering The site is working well but after upgrading I decided to continue with the mount-SPContentDatabase and most of the webparts are working well but I am getting this error when I try to connect two webparts using ConnectionProvider and ConnectionConsumer in the webpart: The control type 'xxx' is not allowed on this page. The type xxx could not be found or it is not registered as safe. All webparts are registered in the webconfig. I appreciate any help you can offer me

[@eng.abubakradlan8161]

Many Thanks..

[@cambodiatoday]

Thanks!!!

[@ShanesCows]

No problem!

[@coorgooty620]

Why so irritating sound at the beginning. ;(

[@ShanesCows]

Sorry you don’t like it. In future videos the intro changes.