Share via

Import-SPWeb from onprem to Teams SP list

sco gordo 301 Reputation points
2020-08-26T16:53:46.927+00:00

Hello!
I have a SharePoint 2016 list with 2.2mil items, all small (around 5kb each, so 11GB). There's a workflow to expire items after x months. We've been seeing sql errors against the contentdb containing the list, and more new items are generated than being expired. I suspect it's the Expiration Policy Timer Job, even though it's not showing errors or continuously running. The business is reluctant to reduce the number of items being generated, etc.
There is a little BI working against the list items, looking for terms like "error" or "slow" or etc. The results appear as a dashboard.
We are in the pilot stages of using Teams and o365. My thought is to export the on prem list, create an ContosoTeam, add a SharePoint list within it (ContosoEmails), import the onprem list items to the Teams ContosoEmails. The ContosoTeam admin or owner could then manage the list growth and etc, and let the Expiration Policy run there, outside of our onprem content db and removing that interference.
The custom BI application would read from the new location in Teams > ContosoTeam > ContosoEmails via connection string or etc.
This sound doable? Common hybrid practice?
Thanks!

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,014 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,591 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,864 questions
0 comments
Accepted answer
  1. Trevor Seward 11,691 Reputation points
    2020-08-26T18:41:24.747+00:00

    You have to perform a content migration, there isn't a method to save as template and import it to SPO (and SPO drops the idea of using classic style 'templates'). Microsoft provides Migration Manager, SharePoint Migration Tool, but there are third parties you may want to investigate such as Sharegate.

    You will also need to replace your workflow with Power Automate as SharePoint 2010 workflows are being retired, and SharePoint 2013 workflows will be retired but no current date is set.

    In other words, you should be looking at re-architecturing the solution you have to fit within SPO/Teams -- i.e. you may want to move your BI process to Power BI, use Power Automate for workflows (or possibly webhooks + custom code, Azure Runbooks, etc.).

    SQL errors are not likely related and may be something worth investigating closely.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest