Category Archives: Configure

My Role as Data Migration Lead – SharePoint 2013


As part of any large ITO deal within a large IT organisation you are sucked into accounts on a particular role to fulfil a particular contractual obligation. I spend the best part of a year on such an account. My role was the Data Migration Lead for one of the largest implementations of a SharePoint 2013 farm in the UK. The SharePoint farm is to be used by 140,000 people across the UK and has over 40 servers! My role was to facilitate the migration of existing solutions to SharePoint 2013 (On-premise).

Problem Scenario

A large public sector organisation within the UK government currently have a number of internal online solutions which provide various facilities such as team collaboration, blogs, wikis, document storage and a managed publishing intranet site. Each solution uses a different tool to provide said service. For example team collaboration uses Documentum eRooms. The managed publishing site uses Oracle Stellent & Publishing Server. The majority (all except the intranet solution) have been implemented as pilots which have turned into production systems without any proper testing or capacity planning. This has been due to the lack of business focus on a particular solution and new tools being introduced over a span of 10 years. To remedy this, a project to combine these existing web based services to a new platform – SharePoint 2013 (On premise) is being undertaken. As part of the new solution there is a great desire for one platform for all ‘web based’ services and to migrate any data from the existing tools.

My Initial Thoughts

I have never been involved in a migration of this scale. I thought I have a solid understanding of SharePoint, I have the capacity to analyse existing solutions and I understood what the end result needs to be. So how difficult could it be? Very it turns out!

To summarise I had to:

  • Migrate all existing web services to SharePoint 2013
    • Provide a Collaboration service (Team Sites, My Sites, Blogs & Wikis, Self-service creation etc…) with existing data
    • Provide a Publishing Intranet site with current content
    • Influence the design of the SharePoint 2013 based on current solutions

My Approach

My first task was to develop a migration strategy. This was a plan of attack. How would we migrate each solution in its current form to SharePoint 2013. First things first, I googled ‘data migration strategy’. The results came up with a number of slides and articles with useful pieces of information which got me thinking. From all this information I came up with three very high level steps. The first step is to understand the ‘as is’. The second the ‘to be’. The third to map the two.

  1. The ‘as is’ is the current solutions. It was to understand and gather system information, usage stats, any customisations, understanding if the current solution maps to SharePoint OOTB functionality, any bespoke features are required.
  2. The ‘to be’ would be a little more difficult in this scenario as it was yet to be decided at this point. But this gave me the opportunity to work with the development teams and SharePoint leads to help shape the solution to match the requirements of the data migration based on the clients’ needs.
  3. So matching the ‘as is’ and ‘to be’ would require some magic or a third party tool? Magic wasn’t really my thing so I opted for a third party tool. So I looked at some of the market leaders such as AvePoint & MetaLogix. Both provided very similar functionality for a similar sort of price. They enabled the existing solutions to be migrated to SharePoint 2013.

So with these three key steps identified, I decided to delve a little deeper into what is required. I formalised my approach into three phases:

  • Analysis – This phase was designed to understand the ‘as is’ and help define the ‘to be’. It was set out provide guidance policies and understanding the current Information Architecture and how that would be translated on the SharePoint 2013 platform.
  • Approach – This phase was to plan and understand pre and post activities in detail. This included the selection of a third party tool, a success matrix, mapping documents and implementation plans (delivery, roll back communications)
  • Delivery – This phase was to implement the plan outlined and measure the success.


Great! We are nearly there, or so it would seem….

So I had a strategy and it was agreed by all parties. Then came the analysis and workshops to understand the finer details. This is a time consuming process as business stakeholders and end users have day jobs and need to be available to help you to understand the ‘as is’ solutions. Getting agreement from the business on which data sources are to be migrated is a must. The owners, administrators and users of the existing solutions provide an insight into:

  1. How these tools are currently used?
  2. How they can be improved?
  3. What their priorities were?

After understanding the ‘as is’ it was time to create the relevant documentation to enable the delivery of the migration. This involved the implementation plans, success matrix, communication plans, roll back plans etc. As we opted to use a third party tool to aid in the migration, a procurement process was instigated to ensure the correct tool was selected based on fair and measurable criteria. As these items progressed the business needed to agree and cleanse the data they had created over the past 10 years. This, as you can imagine was a laborious task which still being undertaken today! This approach has been a great way to structure a migration which focuses on business needs and provides solutions to existing pain points. It provided a solid foundation to adapt when required during the process and provided a road map for the team implementing the migration.

Its high level approach was intentional as it needed to provide flexibility to allow for a variety of data sources. It did take into account that the destination: SharePoint 2013.

To Summarise

Below I have highlighted some key points to consider when undertaking a data migration to any SharePoint farm:

  • If you have more than one data source in the ‘as is’ – verify if all are required by the business
  • Consider cleansing your data in the ‘as is’ before migrating
  • Understand the ‘as is’ solutions and how they currently function in detail
  • Understand your SharePoint implementation – which services are enabled, features, edition etc…
  • Look at it from all points of view – SharePoint Roles, End Users, and Business Stakeholders etc.
  • Priorities – Understand which ‘as is’ solution has the biggest impact on the business and which will provide a quick win
  • Agree a scope of work – what is to be migrated exactly, number of versions, any functionality etc.
  • If you are using a third party tool, ensure you have the right tool for the job. Test it. Make sure it can do what you need.
  • Ensure you have a roll back plan – just in case J
  • Ensure you communicate with the business when and how these changes will affect them
  • Measure the success of the migration by using a success matrix – use the end users to quantify the success.

Hopefully my experience with this process has been useful to you. If you have any questions or comments please feel free to get in touch… Happy migrating!


Tagged , , , , , , , , , ,

SharePoint Resources by Rackspace

Here is a link to a SharePoint resource centre created by Rackspace. It has got some great tutorials by MVPs and other useful tid bits, enjoy!

Click here.

Tagged , ,

SharePoint 2013 Support for Windows Server 2012 R2

Bill Baer (Senior Product Marketing Manager – SharePoint) @ Microsoft has mentioned on his Blog that SharePoint 2013 isn’t compatible with Windows Server 2012 R2 currently. Work is in progress to remedy this in the form of the first service pack for SharePoint 2013, but there is no date for this yet. For the latest information check on Bill’s Blog here.

Tagged , , , ,

SharePoint 2013 & Anti Virus

SharePoint 2013 & Anti Virus

A great article on SharePoint 2013 and Anti virus for streaming data.

Tagged , , ,

SharePoint 2013: Distributed Cache Service

A very useful cheat sheet to understanding the Distributed Cache Service within SharePoint 2013.

Link: click here

Many Thanks to Sean McDonough from

Tagged , , , , , ,

Quick SharePoint 2010 Audit

A great little script to do a quick audit of a SharePoint 2010/2013 farm:

Note: Make sure you run the script from a PowerShell command window and have set your Execute Policy to unrestricted.

Tagged , , ,

SharePoint 2013 Installed on a Single VM

SharePoint 2013 Installed on a Single VM

A great link to a get around having a Domain controller and SQL Server VM installed on a host machine to install SharePoint 2013.

Tagged , , ,

SharePoint 2013 Search

I know its been a while, but I am back now!

Work, Life, Home generally get in the way of me updating my blog more regularly. 🙂

But here we go again …

Here is a list of some of the cool new features in SharePoint 2013 Search:

  • Continuous Crawl – as soon as you add something to a site, the ability have it appear immediately in the results.
  • Hover Panel – A look at snapshot of a document and a brief summary
  • Expertise Search – a tool which allows searching of social profiles within SharePoint
  • Query Rules – Query Rules allows to have search requests from a user trigger multiple queries and multiple result sets

Here is some more detail:

Tagged , , , , , , ,

SharePoint 2013 Installation and first impressions

I know, I’m a little late to the game – but I have been working hard on projects which get in the way of doing fun stuff like this! So I have installed and had a brief look at MS SharePoint 2013 using the MSDN developer preview. It looks interesting, lots of intergration with social networking, syncronisation of data (at an enterprise level) and ‘Apps’. Here is a breakdown of what I did and road blocks I encountered:

  • I downloaded the developer preview from MSDN
  • Installed on W2K8 R2 (running on a VirtualBox VM)
  • Loaded the installer, Pre-reqs installed without issues.
  • I then ran the Installer, which completed successfully
  • Issue 1 – I could not create the Config database, luckily someone else had already overcome this problem –
  • Issue 2 – The last step failed – creating sample data but reading around its not a big problem as SharePoint is still configured.

So all in all not a smooth installation, but it is a developer preview!

So my inital thoughts where:

  • Nice touches to UI (Windows 8 style)
  • Ability to embed code (this is I beleive is to help with how Apps will run)
  • Everything is App-centric! – Everything is an App! A document library is an app, a web part is an app, a site is an app – you get the picture 🙂

I will be doing a few more deep dives in the coming weeks – exploring SP designer and other features – so make sure you come back for more!

Happy SharePointing! 🙂

Tagged , , , , , , , , , ,