ATPI outsourced the upgrade of its existing Microsoft SharePoint Server (MOSS) 2007 environment to SharePoint 2010 to AvePoint partner KPN Consulting. The primary use of SharePoint for ATPI was to support collaboration and information sharing across the various offices within the company.
End-user data was dispersed across four web applications hosting 36 site collections in 10 content databases, with an approximate total size of 460 gigabytes (GB). After the upgrade and migration, all site collections needed to be consolidated into a single web application in order to reduce support and maintenance effort for the environment.
Besides upgrading ATPI’s SharePoint environment, other project objectives that KPN Consulting helped with included improvements in user authentication (from both internal and external locations), navigation across site collections, and findability of content.
The initial approach was to use the Microsoft database attach methods and restructure the data using built-in Windows PowerShell cmdlets to export and import data. During the first production upgrade attempt, the upgraded site collections and underlying document libraries were ready to be restructured to match the new structure of a single web application and site collections for each team.
A first attempt was made to restructure the upgraded site collections and underlying content, located in a single document library consisting of 400,000 items with sub folders for each department using SharePoint’s native tools for exporting and importing. These tools did not provide the expected flexibility and performance to successfully complete the data migration within the service window, which was one weekend.
SharePoint’s native exporting and importing tools were not designed to relocate specific folders – including underlying subfolders with more than 10,000 documents – from the old document library to the new document libraries in separate site collections for each team and department within a reasonable timeframe. Because of this, an alternative needed be found quickly to finalize the migration for ATPI.