The first step is very important to ensure data imports to SharePoint with no errors. Let’s get started! Step 1: Review the exported CSV dataset to ensure that the To ensure that the SharePoint fields match the CSV data In this blog, I will explain the steps I took to create a more simplified method for data migration and demonstrate how you can do this in your environment. In order to make this process more automated and streamlined, the best tool to use is PowerShell. If I were to achieve this objective by migrating the data manually it would be an extremely time-consuming, inefficient process. After analyzing the current dataset from the CSV file provided by the customer, I discovered my customer was generating around 70,000 records a year and wanted to migrate three years’ worth of records.Įssentially, my objective here was to migrate the historical data (210,000 records) provided in a large CSV file to a new system designed in SharePoint Online. Once the application was ready to go live, my customer requested to move their historical data from the Microsoft Access database to the new system. I came across a situation with a customer whilst on a project developing a custom application utilizing SharePoint Online. What if we need to migrate historical data from a legacy system? SharePoint is evidently a great opportunity to enhance business processes, but What makes this even more valuable, is that Microsoft increases this limit almost every year at Ignite. In the most recent Microsoft update to the core design, lists can now handle a phenomenal 30 million records, therefore providing organizations with scalable record management systems for business applications. Secondly, SharePoint lists is a highly efficient system for managing records. Firstly, most of the core functionality, such as security, data management and more are already in place, meaning one less job for developers. SharePoint is a widely popular tool amongst developers for many reasons.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |