Real World : Migrating Site Collections to SharePoint 2013

1. Real World : Migrating Site Collections to SharePoint 2013 Marrell Sanders – Sr. SharePoint Administrator SharePoint Saturday Dallas / Ft.Worth| March 7th, 2015

2. Who Am I Marrell Sanders, MCTS • SharePoint Administrator – IT Pro • Applications Instructor • Senior Web Consultant (MS Group IT) Contact • Email: techrevmarrell@outlook.com • Blog: www.techrevmarrell.com • Twitter: twitter.com/TechRevMarrell

3. What is this session about? • Migrating SharePoint site collections. • Migration content into SharePoint 2013, Office 365 • Planningand Pitfalls • Tools and Resource to get it done. • Real World examples

4. Upgrade SharePoint VS Site Migration VS Content Migration • Upgrade SharePoint = Database Upgrades • Site Migration = Site level move • Content Migration =Libraries, Lists, or Importing from other locations. • Who’s the real MVP? • My friends, uncles, co-workers, nephew said…

5. What’s your plan? • How will you get from Point A to Point B? • Reality is it’s usually from Point A to Point Z? “Failing to plan is still a plan. It just usually costs more time and money.” (tweetable) TweetableSyllabification: tweet·ablePronunciation: /ˈtwēdəb(ə)l/ Definition of tweetable in English:adjectiveSuitable for posting on the social media site Twitter:

6. What’s your plan? Get the right people together in order to ask the right questions!

7. What’s your plan? • Get Checklist(s) • Get Inventory • Get Permission • Get Schedule

8. How do I do the move? • SharePoint 2007 Sites? • DB Attach to SP2010 • stsadm.exe -o preupgradecheck If you have customizations in your 2007 sites, prepare to push back that vacation you had planned. (Or your admins)

9. How do I do the move? • SharePoint 2007 Sites? • DB Attach to SP2010 • Analyze the report and Fix the following settings:• Identify any third party components used and deploy them to SharePoint 2010 and SharePoint 2013 site. E.g. Nintex, 3rd party features, including web parts, solutions and custom workflows• Setup Incoming/Outgoing email settings in SharePoint 2010 and SharePoint 2013environment• Modified Web.Config entries• Configure Alternate Access Mappings (AAM)• Find the missing webpart, event receivers or features if any and delete them

10. How do I do the move? • SharePoint 2007 Sites? • DB Attach to SP2010 • Analyze the report and Fix the following settings:• Backup the databases from the Old SQL instance• Restored the databases in the new SQL instance• Modified Web.Config entries• Configure Alternate Access Mappings (AAM)• Find the missing webpart, event receivers or features if any and delete them

11. How do I do the move? Third Party tools such as: • Sharegate • Ave Point • Metalogix • Metavis • Dell • Varonis • Etc… (note: This is not an official ranking of Top to Bottom vendors.)

12. How do I do the move w/Content Only? • 3rd Party Tool • Preserves Meta Data in content • Modified By, Modified Date, Library Column data • Reporting • Scheduling • Versioning • Has some intelligence • Explorer View • Lose Previous Meta Data • Visual Comparison tool • Shortcut Key Scheduling • Fire and Forget Technology

13. 1.moved 300GB of data from SharePoint 2003 to SharePoint 2007. (Failed scenario’s when explorer view copy and paste, due to network hiccups etc) 2.600 site collections in SharePoint 2007 -> SharePoint 2010, 2013. Real World Applications • Why would I ever want to do this? • Moving file shares of data into Departmental libraries with specific meta tagging. • Take advantage of newer technologies o365, SharePoint 2013 newsfeed. • Yammer!!!

14. Pitfalls and Limitations • Time investment • Resource investment • Coordination efforts • Hardware Specifications • Complexities • Customizations • Versioning

15. Questions Additional Resources: http://www.TechRevMarrell.com #SPSDFW blog post for downloadshttp://www.winwire.com/moss-2007-to-sharepoint-2013-migration-using-database-attach-method/