Migrate List template from SP 2010 to SP 2013

Question

I've a list with data in a SharePoint 2010 and i need the same in SharePoint 2013. The list contains the lot of items with the versioning. I tried saving the list as a template and used it in SharePoint 2013 but the system is throwing an error. Can anyone tell me how to get the list from SP 2010 to SP 2013 along with the versions ? Thanks in advance.

Madhanmohan Devarajan · Answer

Here is the exact same scenario of yours. In the below link the approach i have mentioned is also there (Option 3). Hope 2nd option may work for you. How to move a List from SharePoint 2010 to SharePoint 2013 Fast & Cheap : “Dirty” export and import Fast & Clean : Third party solution Clean & Cheap: Content Database Import https://absolute-sharepoint.com/2013/08/how-to-move-a-list-from-sharepoint-2010-to-sharepoint-2013.html

Sasikumar Yuvaraj · Answer

Hi Mathan, Thanks for your advise. The problem is we don't have the db or central admin access except the IT team. Is there any third party tool to migrate only the list?

Madhanmohan Devarajan · Answer

Sasi, You can't take the list template of SharePoint 2010 and create a list in 2013. Reason is both 2010 and 2013 has different schema at the content DB level. May be if you have content DB access to 2010 then you can restore the content DB in SQL Server where the SP 2013 content DBs are existing. After that create a new site collection (test) and then attach the 2010 content DB to the new site collection, execute the powershell command to Test and Upgrade the content DB. In this approach you will get the versioning and all other properties of the list. Or else you may have to use powershell / third party tool to port data from SP 2010 to 2013, but i am not sure whether you will be able to get the versioning stuffs.