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.

Write a comment

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

Reine

About

Reine is a web developer who enjoys caffeine-fueled urban traveling. More...

RSS @reinel Instagram