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

Sessions in Seville

"I end my journey in front of the tomb of Columbus, located inside the world’s largest Gothic cathedral."

Roaming through Banff

"Even though the main town is surrounded by mountains with names such as Sulphur Mountain, it is as far away from Mordor as one could imagine."

New Years Eve in Sydney

"Opera House is seen in front of the massive fireworks in the harbor area, celebrating the 75th anniversary of the Harbour Bridge."

Bunker safari

"The area contains 54 excavated bunkers along with gun emplacements, scattered around the town’s most visible landmark."

Road trip across the American Southwest

"We drove along Route 6, Route 66 and Route 666. If there was a Route 6666, we must have missed that turn."

Exploring Chernobyl

"But unlike the movie Chernobyl Diaries, we didn’t find anybody there. Nature had reclaimed the area and the silence was deafening."