Skip to main content

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]
Location: Sydney NSW, Australia

Comments

Post a Comment

Popular posts from this blog

How to convert the Sitecore patch package to SCWDP packages

1 - First, make sure all the prerequisites are installed:  https://doc.sitecore.com/developers/sat/24/sitecore-azure-toolkit/en/getting-started-with-the-sitecore-azure-toolkit.html 2 - Download Sitecore Azure Toolkits. The latest version is at  https://dev.sitecore.net/Downloads/Sitecore_Azure_Toolkit/2x/Sitecore_Azure_Toolkit_240.aspx . Extract the downloaded zip to local directory, for example: c:\sat24 3 - Open PowerShell, navigate to c:\sat24 # import Sitecore Azure Toolkit module comlets Import-Module .\tools\Sitecore.Cloud.Cmdlets.psm1 -Verbose Import-Module .\tools\Sitecore.Cloud.Cmdlets.dll # convert the Sitecore Patch zip package to SCWDP package. A scwdp file will be created at C:\scwdp\SC Hotfix XXXXXX-1 XXX rev.200610.scwdp.zip ConvertTo-SCModuleWebDeployPackage -Path "C:\temp\SC Hotfix XXXXXX-1 XXX rev.200610.zip" -Destination "C:\scwdp" # create a nodb version of the patch deployment package for CD and continuous deployment. Another scwdp file will be...
Post a Comment
Read more

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

Sitecore Version from Sitecore.Kernel.dll 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
Post a Comment
Read more

Find and replace Sitecore license in every corner (XP 9.2)

You may need to replace your Sitecore licenses, because the license has expired or you need upgrade the existing one. Since Sitecore 9.* has added some XP roles, plus the service workers, it's not an easy job to find and replace all the licenses any more. Here, I am going to explore the Sitecore installation packages to find out where are the Sitecore license located for each role and service worker. XP Single Role: single License path:  App_Data\license.xml [kudu: cd site\wwwroot\App_Data] Role: xc-connect License path App_Data\license.xml [kudu: cd site\wwwroot\App_Data] App_data\jobs\continuous\IndexWorker\App_Data\license.xml [kudu: cd site\wwwroot\ App_data\jobs\continuous\IndexWorker\App_Data] App_data\jobs\continuous\AutomationEngine\App_Data\license.xml [kudu: cd site\wwwroot\ App_data\jobs\continuous\AutomationEngine\App_Data] App_data\jobs\continuous\ProcessingEngine\App_Data\license.xml [kudu: cd site\wwwroot\ App_da...
1 comment
Read more