Mink Machine

EPiServer database version list

Just as the EPiServer CMS version numbers are a bit tough to remember, the corresponding database versions are even worse.

Typically you don’t really need to bother, since this stuff is taken care of by the Deployment Center. But if something goes wrong you may need to apply database upgrade scripts by hand, and then you really need to know the correct numbers.

  • CMS 6 R2: 6103
  • CMS 6.0: 6004
  • CMS 5 R2 SP2: 5205
  • CMS 5 R2 SP1: 5202
  • CMS 5 R2: 5200
  • CMS 5 R1 SP3: 5102

If you are unsure of your current version, there is a stored procedure called sp_DatabaseVersion which will return the correct version.

If you need the upgrade scripts, they can be found here:
C:\Program Files (x86)\EPiServer\CMS\[version]\Upgrade\Database\sql (or similar).

The folder contains a lot of scripts which need to be run in correct order. The naming can seem a bit scary at first (e.g. 0005_0001_0422_0004to0005_0001_0422_0122.sql), but if you look closely they actually match the assembly versions.

Example:

0005_0001_0422_0004to0005_0001_0422_0122.sql 0005_0001_0422_0122to0005_0001_0422_0252.sql … 0006_0001_0237_0000to0006_0001_0287_0000.sql 0006_0001_0288_0000to0006_0001_0316_0000.sql

The first file upgrades from 5.1.422.4 (just skip the zeros) to 5.1.422.122, where 5.1.422.4 is the assembly version of CMS 5 R1. The scripts continue in order all the way up to the latest version of CMS 6.

Related posts

Comments

No comments yet.

Post a comment

Your email address will not be published. Required fields are marked *

Featured stories

Eating my way through Basque country

"Not too bad to wash it all down with a local Txakoli, the young white wine typical of the Basque country."

Visions of Singapore

"By extensive use of landfill with sand bought from Indonesia and Cambodia, the bay area has expanded greatly in the last few years and tall buildings pop up everywhere."

Roaming in Valletta

"I passed the statue of Jean de Valette, the 49th Grand Master who laid the foundation stone to Valletta in 1566, to gaze at the golden interior of St. John’s Co-Cathedral, where he is buried in the crypt."

Good morning Montenegro

"One would almost think that all this secrecy was made on purpose to keep the hordes of tourists away. Let them all perish in the crowds of Dubrovnik while the people of Montenegro can enjoy their beautiful country on their own. Or something like that."

The dark days of Sarajevo

"The city survived on the edge of annihilation and has started to recover, but the stone walls still seem to cry out in lament of all the horrible things they have seen."

I still love you, New York

"Now I’m back and our roles are somewhat reversed. Like River Song and the Doctor, we meet again under different circumstances."