{"id":482,"date":"2009-04-04T13:11:00","date_gmt":"2009-04-04T13:11:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2009\/04\/04\/sharepoint-list-migration-approaches\/"},"modified":"2009-04-04T13:11:00","modified_gmt":"2009-04-04T13:11:00","slug":"sharepoint-list-migration-approaches","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/","title":{"rendered":"SharePoint List Migration Approaches"},"content":{"rendered":"<div class=\"ExternalClass329C2B7E863240498E67F550F8540B42\">\n<p class=\"ExternalClassDAC8EB747C1D4ABBB1673B0279CDD75E\">I frequently find myself helping small business &#8216;migrate&#8217; data from one SharePoint site to another (usually because they rushed into their first site design and realized after the fact, that wanted to start again, but to take some data with them). So, okay, business is business, I&#8217;m always happy to help. The challenge is, which approach does one use? So, I&#8217;m going to start building and maintaining a list of approaches one can take and try to point out the key benefits and drawbacks. <\/p>\n<p class=\"ExternalClassDAC8EB747C1D4ABBB1673B0279CDD75E\">At this writing, this list is hardly definitive or complete but for a Saturday morning while I hang with my kids as they play Lego Star Wars on the Xbox 360 (great game for kids, I think, fun, challenging and harmless), I thought I&#8217;d get this thing started. <\/p>\n<p class=\"ExternalClassDAC8EB747C1D4ABBB1673B0279CDD75E\">\u00a0<\/p>\n<h1 class=\"ExternalClassDAC8EB747C1D4ABBB1673B0279CDD75E\">Reference Links <\/h1>\n<p class=\"ExternalClassDAC8EB747C1D4ABBB1673B0279CDD75E\">Looking for a whack of information, details and goodies on all approaches, try these links: <\/p>\n<div class=\"ExternalClassDAC8EB747C1D4ABBB1673B0279CDD75E\">\n<ul>\n<li><a>Copying or moving SharePoint lists<\/a> <\/li>\n<li><a href=\"http:\/\/office.microsoft.com\/en-us\/sharepointdesigner\/HA100699391033.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">Back up, restore, or move a SharePoint site<\/a> <\/li>\n<li><a href=\"http:\/\/blog.henryong.com\/2008\/01\/21\/how-to-movemigrate-sharepoint-list-itemsdocuments-and-preserve-metadata-properties-at-the-same-time\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to move\/migrate SharePoint list items\/documents and preserve metadata properties at the same time<\/a> <span style=\"color:#c0504d\">(Note: MOSS Only)<\/span> <\/li>\n<li><a href=\"http:\/\/boris.gomiunik.net\/2009\/04\/migrating-sharepoint-content-between-different-site-templates-and-preserving-all-the-necessary-metadata\">Migrating SharePoint content between different site templates and preserving all the necessary metadata<\/a><\/li>\n<\/ul>\n<\/div>\n<p>\u00a0<\/p>\n<h1>Save List (or library) as Template (with Content) <\/h1>\n<p>This is the quick and handy way of doing this frankly. By saving the list as a template (and choose the &#8216;include content&#8217;) option, you can then go to your list template gallery, save the list to your computer and then upload it to another site and create a new list, based on that list template. <\/p>\n<p><span style=\"color:#9bbb59\"><strong>Pros<\/strong><\/span>: <\/p>\n<ul>\n<li>Quick, Easy, Efficient <\/li>\n<li>Works really well, most of the time <\/li>\n<\/ul>\n<p><span style=\"color:#e36c0a\"><strong>Cons<\/strong><\/span>: <\/p>\n<ul>\n<li>Kiss your modified dates, author time stamps and version history goodbye \u2013 they aren&#8217;t coming with you with this method. If you don&#8217;t care about that, then no worries <\/li>\n<li>There is a 10MB limit on the size of lists (and this applies to saving site template as well). Thus, if you are planning to use this to &#8216;move&#8217; a large document library \u2013 forget it. You are better off saving your document library as a template *without* content and then using the Windows Explorer view (Actions, Open in Windows Explorer) to cut and paste your data \u2013 if in fact, that is manageable for you.\u00a0 Note: I outline how to overcome the 10MB limit <a href=\"\/archive\/2009\/05\/10\/save-sharepoint-list-as-template-with-content-maxes-out-at-10mb-\u2013-but-i-want-more\u2026.aspx\">here<\/a>, though don&#8217;t think you&#8217;ll be able to use this approach for anything too big &#8230; Reference: <a href=\"\/archive\/2009\/05\/10\/save-sharepoint-list-as-template-with-content-maxes-out-at-10mb-\u2013-but-i-want-more\u2026.aspx\">http:\/\/brainlitter.com\/archive\/2009\/05\/10\/save-sharepoint-list-as-template-with-content-maxes-out-at-10mb-%e2%80%93-but-i-want-more%e2%80%a6.aspx<\/a><\/li>\n<\/ul>\n<p>Boris Gomiunik has a handy step by step procedure here utilizing save as template, combined with some other techniques, to maintain your metadata as well: <a href=\"http:\/\/boris.gomiunik.net\/2009\/04\/migrating-sharepoint-content-between-different-site-templates-and-preserving-all-the-necessary-metadata\/\">http:\/\/boris.gomiunik.net\/2009\/04\/migrating-sharepoint-content-between-different-site-templates-and-preserving-all-the-necessary-metadata\/<\/a><\/p>\n<p>\u00a0<\/p>\n<h1>Save Site as Template (with Content) <\/h1>\n<p>Like above, you can do the same with a template and the same rules\/situations apply. No version history, the site can&#8217;t be large (file size), etc. But sometimes you might want to pick up a small site that has considerable customization and make it a subsite of your new site instead. As well, here&#8217;s a blog post I wrote (<a href=\"\/archive\/2009\/01\/17\/how-to-add-a-site-collection-template-to-central-administration.aspx\">http:\/\/brainlitter.com\/archive\/2009\/01\/17\/how-to-add-a-site-collection-template-to-central-administration.aspx<\/a>) to explain how to make your *root* site, in your site collection, based on a template (as you need it to add it to the Central Admin gallery. <\/p>\n<p>\u00a0<\/p>\n<h1>Export to Spreadsheet (and then import the Spreadsheet) <\/h1>\n<p>Personally, I never use this method. It&#8217;s a pain, rarely proves fruitful and is more work than necessary. Plus it comes with its own set of other drawbacks. Funny though, most people start here when they don&#8217;t know any better, strangely enough. Maybe I&#8217;ll be helping encourage folks to abandon that approach now\u2026 <\/p>\n<p>\u00a0<\/p>\n<h1>Copy from one Datasheet View to the Datasheet View in another list <\/h1>\n<p>This can work, but it is now up to you to configure the destination list manually (customizations, custom columns \u2013 all gone), thus this is a really inefficient approach as well \u2013 and you won&#8217;t get your version history with this either. <\/p>\n<p>\u00a0<\/p>\n<h1>3<sup>rd<\/sup> Party Tools <\/h1>\n<p>\u00a0<\/p>\n<ul>\n<li>If you have the dough, they exist. Quest, AvePoint each have tools you can buy \u2026 if you can spare the change. <\/li>\n<li><a href=\"http:\/\/www.sharepointproducts.com\/products\/default.aspx\"><strong>CopyMove<\/strong><\/a>\u00a0(sharepointproducts.com) Looks very promising as well and the 2 user, single server tool is free to try.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<h1>STSADM -o Export <\/h1>\n<p>I&#8217;ve documented this in another post so I won&#8217;t go into a lot of detail here.\u00a0 But, one approach might be (particularly if you want to bring some version history across), is to export and import the old site, as a new subsite, and then delete the lists and libraries you don&#8217;t need.\u00a0 See how here: <a href=\"https:\/\/itgroove.net\/brainlitter\/archive\/2009\/05\/11\/how-to-backup-and-restore-migrate-a-single-sub-site-of-a-sharepoint-site-collection-using-stsadm-\u2013o-export-and-import.aspx\">http:\/\/brainlitter.com\/archive\/2009\/05\/11\/how-to-backup-and-restore-migrate-a-single-sub-site-of-a-sharepoint-site-collection-using-stsadm-\u2013o-export-and-import.aspx<\/a><\/p>\n<p>\u00a0<\/p>\n<h1>SharePoint Database Exporter <\/h1>\n<p>Though I only discovered this today, thus the inspiration as it were, for my post, this looks promising, particularly as the dude has sorted out exporting lists\/information and the history. <\/p>\n<p>Link: <a href=\"http:\/\/blog.dreamdevil.com\/index.php\/tag\/sharepoint-database-exporter\/\">http:\/\/blog.dreamdevil.com\/index.php\/tag\/sharepoint-database-exporter\/<\/a> <\/p>\n<p>(Caution): I&#8217;m not exactly endorsing this tool as it were, more so, bookmarking it for later (and for myself, that is the reason we blog, kinda, right? So we can find those nuggets easier later) but it looks promising. <\/p>\n<p>As well, I see no mention of an &#8216;importer&#8217; so I gather it is either underway or it is up to us to figure out how to complete that step. \ud83d\ude42 <\/p>\n<p>\u00a0<\/p>\n<h1>SharePoint Designer <\/h1>\n<p>SharePoint Designer offers a couple of choices and as of April 1, 2009, became more available to everyone as well (as it is now free). It includes: <\/p>\n<ul>\n<li>Export\/Import Personal Web Package (I&#8217;ve had limited success with this approach) \u2013 use with caution (test first, to be sure you are clear what you are doing \u2013 you can destroy your destination site if you don&#8217;t target the subsite properly <\/li>\n<li>Backup Website\/Restore Website <\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<h1>Outlook 2007 <\/h1>\n<p>Now, this won&#8217;t apply to every list of course. However, those lists that can interact with Outlook (Announcements, Contacts, Calendars, Document Libraries, Tasks), an approach could simply be (again, you aren&#8217;t taking custom column\/meta information here, but this is quick and simple): <\/p>\n<ol>\n<li>Connect the source list to Outlook 2007 (2003 won&#8217;t work for this as it is &#8216;write&#8217; in SharePoint&#8217; but only &#8216;read&#8217; in Outlook 2003&#8242; \u2013 2007 writes both ways) <\/li>\n<li>Create a new list on the new site and connect it with Outlook 2007 <\/li>\n<li>Drag and drop your content from the one list to the other \u2013 voila! <\/li>\n<\/ol>\n<p>\u00a0<\/p>\n<h1>Access 2007 <\/h1>\n<p>Thanks to Sarah and Jess, I totally forgot about Access.\u00a0 Lots of power in that product for giving you a powerful GUI, to your backend SharePoint content. If you have it installed on your machine, you have some great options there.<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>I frequently find myself helping small business &#8216;migrate&#8217; data from one SharePoint site to another (usually because they rushed into their first site design and realized after the fact, that wanted to start again, but to take some data with them). So, okay, business is business, I&#8217;m always happy to help. The challenge is, which &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[337,14,338,339],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SharePoint List Migration Approaches - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SharePoint List Migration Approaches - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"I frequently find myself helping small business &#8216;migrate&#8217; data from one SharePoint site to another (usually because they rushed into their first site design and realized after the fact, that wanted to start again, but to take some data with them). So, okay, business is business, I&#8217;m always happy to help. The challenge is, which &hellip;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2009-04-04T13:11:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/\",\"name\":\"SharePoint List Migration Approaches - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2009-04-04T13:11:00+00:00\",\"dateModified\":\"2009-04-04T13:11:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SharePoint List Migration Approaches\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SharePoint List Migration Approaches - Brainlitter - Inside the mind of Sean Wallbridge","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/","og_locale":"en_US","og_type":"article","og_title":"SharePoint List Migration Approaches - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"I frequently find myself helping small business &#8216;migrate&#8217; data from one SharePoint site to another (usually because they rushed into their first site design and realized after the fact, that wanted to start again, but to take some data with them). So, okay, business is business, I&#8217;m always happy to help. The challenge is, which &hellip;","og_url":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2009-04-04T13:11:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/","url":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/","name":"SharePoint List Migration Approaches - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2009-04-04T13:11:00+00:00","dateModified":"2009-04-04T13:11:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/04\/sharepoint-list-migration-approaches\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"SharePoint List Migration Approaches"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/482"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=482"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/482\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}