Read time 9 minutes

Summary: This article discusses the importance of SharePoint site collections and the need to migrate them between content databases. It emphasizes prerequisites like database existence and size analysis. The primary method involves PowerShell commands, including moving single or multiple site collections. An alternative solution, Kernel SharePoint Migrator, is introduced, offering a user-friendly approach for site collection migration. The tool’s steps, from setup to migration, are outlined for a seamless transfer between SharePoint servers.

A SharePoint site collection encompasses all your sites, lists, content, and templates, constituting a pivotal component of your SharePoint ecosystem. Nevertheless, there are specific scenarios that may necessitate the migration of your site collection from one content database to another. For example, if a site collection exceeds the capacity of its current content database, relocating it to a more spacious content database becomes imperative. Additionally, consolidating multiple small site collections from various content databases into a single content database can streamline administration and enhance efficiency.

This article will explore the process of transferring a site collection from one database to another using PowerShell commands. Additionally, we offer an alternative method for migrating a SharePoint site collection between content databases.

Things to Know Before Migrating Site Collection

Before beginning the migration, make sure that the following conditions are true:

  • A content database should already exist as a destination
  • The source and destination content database must be located on the same instance of the SQL server
  • The source and destination content database must be attached to the same web application

Additionally, it’s vital to assess the source site collection’s size since the auditing data is transferred when relocating the site collection. In cases of substantial auditing data, PowerShell can be employed to archive and reduce the audit data.

To find the size of a site collection, run the below command in SharePoint Management Shell:
$used = (Get-SPSiteAdministration -Identity <http://ServerName/Sites/SiteName>).DiskUsed

Also, make sure that the destination content database has enough space to accommodate the source site collection. It is recommended to have a free space three times the size of the site collection.

Moving Site Collection Between Content Databases

To move the site collection, you need to use the Move-SPSite command in PowerShell. Using this command, you can move a single site collection as well as multiple site collections to a new content database.

Moving a single-site collection

To move a single SharePoint site collection, you need to have the following memberships – securityadmin fixed server role, db_owner fixed database role, and the administrator group.

  • Open SharePoint Management Shell and type the below command in PowerShell command prompt:
    Move-SPSite <http://ServerName/Sites/SiteName> -DestinationDatabase <DestinationContentDb>
    Here, http://ServerName/Sites/SiteName is the name of a site collection, DestinationContentDb is the name of the destination content database.
Moving Multiple Site Collections

You need to have the same memberships as mentioned above to move multiple site collections from one content database to another.

  • Open SharePoint Management Shell and type the below command in PowerShell command prompt:
    Get-SPSite -ContentDatabase <SourceContentDb> | Move-SPSite -DestinationDatabase <DestinationContentDb&gt;
    Here, SourceContentDb is the name of the original content database and DestinationContentDb is the name of the destination content database.

By employing these commands, the seamless transfer of a site collection from one content database to another becomes a straightforward task. Nevertheless, an alternative approach for migrating a site collection from one server to another involves utilizing the backup and restoration process of the SharePoint site collection.

To safeguard your data, it’s essential to backup SharePoint Site collection using PowerShell. Subsequently, you can employ the same PowerShell technique to restore the Site Collection to SharePoint Server. Nevertheless, if you wish to relocate site collections from one content database to another effortlessly, consider utilizing Move-SPSite, as described earlier.

Alternate Solution to Migrate Site Collections – Kernel SharePoint Migrator

The SharePoint Migration tool, known as Kernel SharePoint Migrator, simplifies the process of migrating between different SharePoint versions. This utility boasts intelligent functionalities that facilitate the seamless migration of site collections between content databases. Whether you need to migrate a single site collection or multiple ones simultaneously, this tool ensures a glitch-free experience. It offers specialized features such as permission migration, selective migration, and migration scheduling. Moreover, you can utilize this utility to transfer data from the File System to SharePoint Server and OneDrive. Its straightforward workflow makes SharePoint Migration effortless, even for non-technical users.

  1. Download and configure the software on your system.
  2. Launch the tool, and the home screen will appear on your screen. Click Add New Source and select SharePoint Server from the drop-down.
    Launch the tool
  3. The Add New Site wizard will appear on your screen. In this section, give a name to the project, provide the Site Address, user credentials, and then click Find Site Collection.
    Add New Site
  4. In the Find Site Collection wizard, provide the required details for SharePoint Site and click Next.
    Find Site Collection
  5. The Site Collection URLs will appear on the screen, select the required Site Collection, and click Finish. The source site will be added to the tool.
    Site Collection URLs
    Note: Make sure you don’t add the same site as both Source and Destination. The tool prompts a message to add the same Server as both Source and Destination while adding SharePoint Server.
  6. Similarly, you can add another SharePoint Server as a destination in the tool.
    add another SharePoint Server as a destination
  7. Once both source and destination SharePoint Server are added. Right-click on the Source Site Collection and select Copy.
    source and destination SharePoint Server are added
  8. Now, in the Destination section, right-click on the SharePoint Server and click Paste.
    Destination section
  9. The migration dialogue box will appear on the screen. Here, you can add another SharePoint Site for Migration, else click Next.
    SharePoint to SharePoint
  10. In the next step, select Migrate as site collection and provide the details for the destination SharePoint Server, and then click Next.
    Migrate as site collection
  11. In the next step, give a Title to the migration process with a description, provide a Site Collection URL, and then click Next.
    provide Site Collection
  12. Select the required copy options and click Next.
    Select the required copy options
  13. You can select whether you want to migrate permissions or not and then click Next.
    migrate permissions
  14. Kernel SharePoint Migrator allows you to schedule the migration process or perform it immediately. You can make your selection accordingly, and then click Next.
    chedule the migration process or perform it immediately
  15. The summary of the migration process will appear on the screen, verify the details, and click Next.
    migration process will appear on the screen
  16. The tool will start migrating Site Collection from the source to the destination.
    tool will start migrating Site Collection
  17. Once the process is complete, a migration summary will appear on the screen, click Finish to end the process.
    process is complete

That’s how you can easily migrate SharePoint Site Collection from one server to another with the help of Kernel SharePoint Migrator.

Conclusion

As site collections expand in size or when there’s a need to consolidate multiple site collections, the migration of site collections between databases becomes imperative. In this context, we will explore the process of transferring a SharePoint Server Site Collection from one content database to another using PowerShell commands. Additionally, we will introduce an advantageous tool called Kernel Migrator for SharePoint designed to facilitate the seamless migration of site collections between content databases.

Kernel Migrator for SharePoint