{"id":6052,"date":"2022-08-26T22:23:43","date_gmt":"2022-08-26T22:23:43","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=6052"},"modified":"2022-09-01T05:32:31","modified_gmt":"2022-09-01T05:32:31","slug":"how-to-compare-two-document-libraries-from-different-office-365-tenancies-sharepoint-sites","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/how-to-compare-two-document-libraries-from-different-office-365-tenancies-sharepoint-sites","title":{"rendered":"How to compare two document libraries from different Office 365 Tenancies \\ SharePoint Sites"},"content":{"rendered":"

Recently I had bit titan migration and the Sharepoint Document Library size of the Source Tenant was 2TB and the destination was only 200GB , quite a bit different , however Bit Titan said everything had copied ok, but I wanted to make sure all the files were there<\/p>

You can show Storage Metrics for a nice overview<\/p>

\"Retained<\/p>

\u00a0<\/p>

There are a few reasons why the sizes might not be like for like\u00a0<\/p>

  1. Bit Titan only copies the last 3 versions<\/li>
  2. Recycle bin isn’t copied<\/li><\/ol>

    How do you compare Source to Destination to make sure everything had copied ok?<\/p>

    1. Export both Document Libraries to Excel\u00a0

      \"\"<\/p><\/li>

    2. Check Column A the Name Column , this is populated with Folders and File names , halfway down my both lists I was getting actual full file paths from some of the files\u00a0\u00a0

      https:\/\/xxxxxxx.sharepoint.com\/sites\/Data\/Shared%20Documents\/xxxxxx\/xxxxx\/xxxxx\/xxxxxx.pdf<\/td><\/tr><\/tbody><\/table>
      This won’t work as the file paths will be different , so I used Excel to give me the file name only\u00a0

      =RIGHT(A77318,LEN(A77318)-SEARCH(“#”,SUBSTITUTE(A77318,”\/”,”#”,LEN(A77318)-LEN(SUBSTITUTE(A77318,”\/”,””)))))

      <\/li>
    3. \u00a0I then copied both columns into a new excel document , selected all and ran a unique compare

      \"\"

      <\/p>

      \"\"<\/p><\/li>

    4. Anything marked as red are the missing files!<\/li><\/ol>","protected":false},"excerpt":{"rendered":"

      Recently I had bit titan migration and the Sharepoint Document Library size of the Source Tenant was 2TB and the destination was only 200GB , quite a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3922,3921,562,942,3923,3924],"class_list":["post-6052","post","type-post","status-publish","format-standard","hentry","category-research","tag-compare","tag-different-tenants","tag-excel","tag-sharepoint","tag-sharepoint-sites","tag-tenacies"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=6052"}],"version-history":[{"count":2,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6052\/revisions"}],"predecessor-version":[{"id":6085,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6052\/revisions\/6085"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=6052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=6052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=6052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}