Deploy the xDB Collection database

Current version: 10.1

Although the xDB Collection database is deployed when you deploy xConnect, you can use the SQL Sharding Deployment Tool to deploy an empty copy of the database. For example, you might want to deploy a database with more shards than the default two.


In Sitecore 9.3 and later, you can use a split/merge service to re-distribute data by adding or removing a shard.

To manually deploy the xDB Collection database:

  1. Install the XP topology of your choice (for example, XP Single or XP Scaled). The xDB Collection database is deployed as part of the installation process.

  2. Browse to the <xconnect-collection-root>\App_Data\collectiondeployment folder. This folder contains a file named Sitecore.Xdb.Collection.Database.SqlShardingDeploymentTool.exe.

  3. Use the SQL Sharding Deployment Tool'sdrop operation to remove the xDB Collection database. This includes the shard map manager and all shards.

  4. Use the SQL Sharding Deployment Tool's create operation to create a database with the number of shards that you want.

  5. If you changed the name of the xDB Collection database, you must update the connection strings of all roles that reference the xDB Collection database.

Do you have some feedback for us?

If you have suggestions for improving this article,