Platform Administration and Architecture

Deploy the xDB Collection database

Abstract

How to use the SQL Sharding Deployment Tool to deploy the xDB Collection database.

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 10 shards rather than the default number.

Note

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.