Sitecore Swamp

Dive in the Sitecore Swamp

NAVIGATION - SEARCH

Update ShardsGlobal for xDB migration (Sitecore 9+)

In Sitecore 9+, xDB data can be stored in SQL databases. To ensure the performance, Sitecore uses Shard databases, see Jason article Sitecore 9 xDB Sharding. The sharding data is managed in ShardMapManager table, which stores the server name and database. It works like a charm, but just one issue. The server name and database is hard references, which can cause problems for data migration. If you are trying to create a Sitecore instance from database dumps, the DatabaseName and ServerName need to be updated in [Xdb.Collection.ShardMapManager].[__ShardManagement].[ShardsGlobal]

 

Sitecore Version from Sitecore.Kernel.dll (8.2.* - 9.*)

Sitecore Version

NuGet Version

Kernel Product Version

Kernel File Version

9.1 Initial Release

9.1.0

12.0.0-r00549

12.0.0.0

9.0 Update-2 rev.180604

9.0.180604

11.1.2-r00461

11.1.2.461

9.0 Update-1 rev.171219

9.0.171219

11.1.1-r00395

11.1.1.395

9.0 Initial Release rev.171002

9.0.171002

11.1.0-r00369

11.1.0.369

8.2 Update-7 rev.180406

8.2.180406

10.0.9-r00605-3092e47

10.0.9.605

8.2 Update-6 rev.171121

8.2.171121

10.0.8-r00560-a977d2d

10.0.8.560

8.2 Update-5 rev.170728

8.2.170728

10.0.7-r00479-015e736

10.0.7.479

8.2 Update-4 rev.170614

8.2.170614

10.0.6.-r00427-7aa1a4e

10.0.6.427

8.2 Update-3 rev.170407

8.2.170407

10.0.5-r00377-d79211d

10.0.5.377

8.2 Update-2 rev.161221

8.2.161221

10.0.4-r00315-8752614

10.0.4.315

8.2 Update-1 rev.161115

8.2.161115

10.0.3-rev.r00309-1d4ac49

10.0.3.309

8.2 Initial Release rev.160729

8.2.160729

10.0.0 rev.160279

10.0.0.5597